[thelist] probably simple SQL question
rudy
r937 at interlog.com
Thu Jan 17 18:21:17 CST 2002
> Use the semicolon to separate multiple sql statements.
don't forget to wrap a transaction lock around the multiple statements
that's to cover the situation where the database server fails after doing
the first statement and before doing the second -- you know, like the
famous example of withdrawing from your savings account and then not adding
to your chequing account
also, you may get an error message on the semicolon, not all databases
support that, so you may have to run separate queries
rudy
More information about the thelist
mailing list