Comments by Jassom - CodeProject

Jassom 10-Aug-20 17:32pm View

I tried it.

Jassom 10-Aug-20 16:47pm View

it doesn't matter if the column names doesn't match.
In case you choose to use (*), only what should match are these below:
1- type of columns.
2- number of columns.

but column names doesn't matter

Jassom 10-Aug-20 16:26pm View

Yes, in case you will not use the (*), You can choose specific columns, as you said.

Jassom 10-Aug-20 15:52pm View

DELETE FROM [dbo].[VISION_SALEHIST4]
GO

INSERT INTO [dbo].[VISION_SALEHIST4] SELECT * FROM [TOMSQLVISION].[VISION_2020].[REAL_PROP].[VW_HSALE]
GO

Note: It must be both tables have the same columns and the same order.

Jassom 10-Aug-20 15:25pm View

You dropped the table at first .. and then how would you insert values into a dropped table???

Jassom 10-Aug-20 15:13pm View

Deleted

SELECT from where??
and
INSERT INTO where??

Jassom 19-May-20 16:09pm View

You will need (Crystal report Developer Edition) just for designing and developing.

So, my suggestion is:
install runtime version on clients, and if the (server) will run reports then install runtime version on it.

No need to install (Crystal report Developer Edition) on the server.

Jassom 13-May-20 15:44pm View

For Crystal Report should install 32bit to solve the problem, no matter what he setup his App (32bit or 64bit).. it will work.

Jassom 10-May-20 22:09pm View

Deleted

Make sure that you use the right parameter of the patient ID you going to delete, is this parameter (lblRowID.Text) is the right ID for the record you going to delete.

Jassom 10-May-20 22:09pm View

Make sure that you use the right parameter of the patient ID you going to delete, is this parameter (lblRowID.Text) is the right ID for the record you going to delete.

Jassom 7-May-20 20:04pm View

Thank you for your clear explanation.

Jassom 6-May-20 16:58pm View

Thank you for reply.
I use the Performance Monitor in Windows to see what is happening, CPU performance is working normal, memory gets full about 95% when storing files up to 250MB.

Jassom 6-May-20 16:55pm View

Thank you for reply.
Encrypt files and decrypt them is also a good idea ..

Jassom 5-May-20 21:18pm View

thank you for reply.

The server is located on the same client machine so I don't worry about database size .. etc. also the reason of why I want to store files in database is becuase the data is sensitive and I don't want others see them outside database.

Comments by Jassom (Top 14 by date)