>Hi
>
>I'm using ODBC to connect to SQL Server in order to serve my application with data. My issue is this:
>
>If I select multiple records from MyTable, lets say 10 records, and I update the field MyTable.Counter with 1 to 10, i.e. the first record MyTable.Counter = 1, MyTable.Counter = 2, MyTable.Counter = 3 etc, etc. When I perform the tableupdate (I am using 5, table buffering rather than row), every record in MyTable.Counter is set to 10. If I suspend the code immediately before the update, the records are 1-10 as you'd expect, but the instant the tableupdate is performed I check on SQL Server and MyTable.Counter = 10 for all 10 records. It would appear that the last record I edit, the changes to that single record are copied across to the other 9 records that I have edited.
>
>Any ideas?
>
>Thanks in advance.
If you run SQL Server profiler, can you see the command(s) send to SQL Server that performs the update?
If it's not broken, fix it until it is.
My Blog