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=
Select and Update-syntax with TMSQuery component
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.
- 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.