SDAC and MSSQL problem
Posted: 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
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