Firebird 2.0
PHP5 Programming
Manual

Overview of Firebird PHP5 Transactions

A transaction is a unit of work on the Firebird server that is either commited as a whole or rolled back as a whole. The transaction functions deal with starting and finalising transactions on the Firebird server.

Syntax

<transaction_function> ::=
     <commit>
   | <commit_ret>
   | <rollback>
   | <rollback_ret>
   | <trans>



Description

The functions to deal with transactions are:

  • commit
    The commit function commits a transaction, drop all open cursors on that transaction and invalidates the transaction handle.

  • commit_ret
    The commit_ret[aining] function commits a transaction, but keeps cursors open and keeps the transaction handle valid.

  • rollback
    The rollback function rolls back a transaction, drop all open cursors on that transaction and invalidates the transaction handle.

  • rollback_ret
    The rollback_ret[aining] function rolls back a transaction, but keeps cursors open and keeps the transaction handle valid.

  • trans
    The trans[action] function explicitly starts a new transaction, with user definable properties. Explicit transactions can span multiple databases.

Default transactions

If a transaction is not explicitly started, then a "default" transaction will be used to execute SQL statements.. If no default transaction exists, a new default transaction is started. A default transaction ends on commit or rollback. The default transaction parameters are: IBASE_CONCURRENCY, IBASE_WRITE and, IBASE_WAIT.


previous page goto index next page

Legal information