>I have a question regarding the tableupdate() command. I was wondering if there was a way, programmatically, to check if a tableupdate() would succeed without it actually doing the update. Something along the lines of a PeekTableUpdate(). The reason for my question is that I have two tables that get updated at the same time and I would like my code to be more elegent in the case of one tableupdate() succeeding and the other one fails. Any suggestions would be helpful.
>
>Mark A. Struck
Mark, wrap your update code in a BEGIN TRANSACTION / END TRANSACTION command. Since each TableUpdate() will return a .T. if it succeeds you can watch for a .F. return, write the appropriate message to the user and do a ROLLBACK.
HTH
Barbara