Hi Steven,
PMFJI, but if your table are in a DBC you can wrap your updates with a BEGIN TRANSACTION - END TRANSACTION.
>Sergey,
>
>I think I may have an even more complicated problem. I have several tables that hold data about a certain record. When a user makes a change the app goes through each table to make the updates. The trouble is three or four tables get updated but one table will return the 'Record is Locked' message. By this time there is not a practical way to go back and do the update. It seems that all the tables would have to be checked first before the update process begain. Any advise on this?
Regards,
Mike
"We try to solve the problem by rushing through the design process so that enough time is left at the end to uncover the errors that were made because we rushed through the design process."
- Glenford Myers
If you're going through hell, keep going. - Walt Disney