FBIRD_COMMIT_RET

Purpose

Use the fbird_commit_ret function to commit a transaction without closing it.

Syntax

<commit_ret> ::=
     fbird_commit_ret( )
   | fbird_commit_ret( tr_hndl )
   | fbird_commit_ret( 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_ret function commits a transaction.The transaction context will be retained, so open cursors opened within this transaction will not be 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_ret();

See also

fbird_commit_ret, fbird_rollback_ret, fbird_rollback, fbird_trans

Extend this topic - Post a comment