note 44945 deleted from function.odbc-autocommit by tomsommer

Note Submitter: rlegend2 at pacbell dot net ---- Making Database workspace via autocommit: <?php $conn = odbc_connect("connection stuff here"); odbc_autocommit($conn,FALSE); // disables autocommit $sql = "some sql"; $sql2 = "some sql"; $ErrorCount = 0; // on execution failure $ErrorCount will increment odbc_exec($conn,$sql) or $ErrorCount++; odbc_exec($conn,$sql2) or $ErrorCount++; //no errors? commit all transactions if ($ErrorCount == 0){ odbc_commit($conn); }// else rollback else{ odbc_rollbak($conn); } odbc_close($conn); ?> Hope this is helpful to someone. Cheers, Ron