Devart Forums

I have a query like

SELECT Fld1,Fld2,Fld3,Fld4,Fld5,Fld6
FROM Table1
WHERE Fld1=

The table is defined with the following indexes:

Key0 / Unique / on Fld1
Key1 / Unique / on Fld2,Fld3

When I update Fld4 and Fld5 and use SQL-monitor I see the following update statement....

UPDATE Table1 SET Fld4=,Fld5=
WHERE Fld1= AND Fld2= AND Fld3=

How can I setup TMSQuery component that I will get the following update statement instead?

UPDATE Table1 SET Fld4=,Fld5=
WHERE Fld1=

Please, check the last version of SDAC (4.50.0.34). It is likely that this problem has already been fixed. If it persists in SDAC 4.50.0.34, send us a small test sample at sdac*crlab*com including script to create server objects. Also supply me the following information:
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMSConnection Editor.