FBIRD_COMMIT

Purpose

Use the fbird_commit function to commit a transaction, drop all open cursors on the transaction and invalidate the handle.

Syntax

<commit> ::=
     fbird_commit( )
   | fbird_commit( tr_hndl )
   | fbird_commit( conn_hndl )

Element 

Type

Description

tr_hndl

resource

A valid transaction handle

conn_hndl

resource

A valid connection handle

<return>

bool

True on success, False on failure

Semantics

The fbird_commit function commits a transaction.The transaction context will be released, so open cursors opened within this transaction will be dropped; the transaction handle is invalidated. This function returns True on success or False on failure.

If called without an argument, this function commits the default transaction of the default connection. If the argument is a connection handle, the default transaction of the corresponding connection will be committed. If the argument is a transaction handle, the corresponding transaction will be committed.

If the transaction handle refers to multiple connections, the transaction is committed on all connections using a two-phase commit protocol.

Example

The below example commits the default transaction on the connection that was opened last:

fbird_commit();

See also

fbird_commit_ret, fbird_rollback_ret, fbird_rollback, fbird_trans

Extend this topic - Post a comment