[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