SDAC and MSSQL problem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
scanc
Posts: 9
Joined: Thu 05 Feb 2009 13:23

SDAC and MSSQL problem

Post by scanc » Thu 05 Feb 2009 13:30

Hello, i'm using SDAC components in my programs and the database is SQLServer based. using a MSQuery i have a problem because it extracts 2 record but when i do edit post it applies the update in 2000 records.

Query:
SELECT FIELD2, FIELD3, FIELD4, FIELD5 FROM TABLE WHERE FIELD1=:FIELD1

FIELD1, FIELD2, FIELD3 are the Keys of the table.

Why did it appens. should i try to set some options in the MSQuery component.

Thanks in advance
Matteo

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 06 Feb 2009 08:59

Please make sure that your table has the unique key, and all fields of this key are included in the SELECT statement of the query.

Post Reply