SDAC and MSSQL problem

[scanc]

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]

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.