>Another question. After issuing UPDATE InvoceHeader SET LockedByUser=UserName WHERE InvoceID=ID and LockedByUser=null, and it fails, the table InvoiceHeader is at EOF(). All subsequent UPDATE's will now fail.
UPDATE will work no matter where the record pointer is when you issue the command. You do not have to GO TOP prior to using this.
>I get around this in VFP by issuing GO TOP IN InvoiceHeader first and then the UPDATE. Would the same thing happen with SQL-Server and how would I issue the same type of workaround?
>
You should be able to send the same statement to SQL server as above.
BOb
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