I have a Client/Server application with remote views against tables in a MS SQL 2000 database. Occasionally, even though TableUpdate() returns .T., the SQL data is not updated. I've confirmed that the correct field value is present before the update is issued.
Table buffering is 5. The statement is:
IF NOT TableUpdate(.T.,.T.)
TableRevert(.T.)
AERROR(laError)
MessageBox(laError(3))
ENDIF
The TableUpdate() is NOT in a transaction (BEGIN/END TRANSACTION).
It has occured frequently on on one paticular workstation (NT4.0) but, recently I've been able to confirm it on my Win 2000 development machine. I can't force it to occur, but it happens often enough that I know that there is a problem.
Any help would be greately appreciated.
Thanks,
Joe
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