|
|
Posted by Tyno Gendo on 04/07/07 19:57
Michael Daly wrote:
> Mr. Newt wrote:
>
>>> Obviously replace with real statements and put your error checking in.
>
> Trying to do multiple updates without checking for errors on each one
> individually is, IMHO, sloppy programming. Doing it as a transaction
> with commit/rollback is advisable.
Agreed, transactions is the best way to go. So long as your database
supports them, worth reading up on them if it does, however I was just
going with what you were currently trying to do :)
I agree with Michael though, do go for transactions if you do want the
multiple table updates, if they are available.
Navigation:
[Reply to this message]
|