Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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()?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement