>>My turn to say "WHOA", Rich. < g > I thought that the way Pascal was doing it
>>is the correct way to do transactions. How can you roll-back changes if you
>>begin the transaction in the Save routine??
>
>Bonnie,
>
>Maybe I'm not the right person to tell you because I found it out myself only a couple of days ago but the right way is :
>- do all updating using buffered tables and views
>- When the user decides to save :
>- BEGIN TRANSACTION
>- tableupdate for each table to update
>- if everthing is OK : END TRANSACTION
>- if not : ROLLBACK, and try to (let the user) resolve the problem(s)
>- if you can't resolve the problem(s), then tabelrevert
>
>Someone in this thread proposed me to look at "Programming for multiuser access" in MSDN ; you should read it, you will, like i did, see the light !
Yep, check out my other post (I wrote this one before I continued reading the thread ... should read 'em all first and then keep my big mouth shut until I finish < g >)
Bonnie