I have this code for updating records in my vfp3 app, which originally came from WIZSTYLE:

BEGIN TRANSACTION
* Try to update all records in selected table
m.lSuccess = TableUpdate(.T.,.F.)	&&successful update
IF m.lSuccess
     END TRANSACTION
     LOOP
ENDIF
ROLLBACK

If you run this code when the record was previously modified by another user, TABLEUPDATE returns .T., which is contrary to what the Help says it should do. Is that because it is wrapped in the transaction? The END TRANSACTION generates the error, of course. Under what conditions would a TABLEUPDATE wrapped in a transaction return .F.?

When used as described, I get Error 1585, which I should trap. What other common errors occur here that I should also trap with specific messages?