ALL OR NOTHING: (works i.e. with MS ACCESS - ODBC)
function prepare()
{ global $conn;
$result = odbc_prepare ( $conn, "CREATE TABLE XX(test int);CRATE TABLE
YY;");
if(odbc_execute($result)){echo "Everything is OK (but shouldn't!).";}
else{echo "Error in the statement. Table XX should NOT be ther
We use the Access-Engine via ODBC. And it sopports rollbacks. But, please,
how could I rollback, what I want to, when I use a p-connection.
For example:
Transaction 1 (UPDATE TAB1...);
Transaction 2 (UPDATE TAB2...);
Between Transaction1 and Transaction2 the Connection to the DB gets
interrupted