>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 !