Re: [PHP-DB] PHP Processing

2004-01-05 Thread fossybeer
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

Re: [PHP-DB] PHP Processing

2004-01-05 Thread fossybeer
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