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