Select and Update-syntax with TMSQuery component

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JeePeeTee
Posts: 3
Joined: Thu 29 May 2008 10:04

Select and Update-syntax with TMSQuery component

Post by JeePeeTee » Thu 29 May 2008 10:13

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=

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 29 May 2008 14:01

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.

Post Reply