General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
>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.
You say you are issuing the update from VFP. Are you doing the update using a remote view or SQLEXEC()?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only