>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?