PHP 4.0 Bug #5803: odbc_rollback fails with MS Access DB but returns true anyway
| From: | vladimir dot prilepsky at roche dot com | Date: | Wed, 26 Jul 2000 21:37:52 +0000 |
| Subject: | PHP 4.0 Bug #5803: odbc_rollback fails with MS Access DB but returns true anyway | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-26404@lists.php.net to get a copy of this message | ||
From: vladimir.prilepsky@roche.com
Operating system: WinNT 4.0
PHP version: 4.0.0
PHP Bug Type: ODBC related
Bug description: odbc_rollback fails with MS Access DB but returns true anyway
I have a hard time to abort transaction
I'm using Access 97
$connection_id=odbc_connection("DSN","","",);
$result=odbc_exec($connection_id, "Select * from table");
odbc_result_all($connection_id);
//prints 5 rows
$result=odbc_exec($connection_id, "Delete * from table where ID=1");
$ suc=odbc_rollback($connection_id);
echo "$suc";
//prints 1 it means rollback succed
$result=odbc_exec($connection_id, "Select * from table");
//prints 4 rows