SQLCOMMIT( ) Function

Example   See Also

Commits a transaction.

Syntax

SQLCOMMIT(nConnectionHandle)

Returns

Numeric

Arguments

nConnectionHandle

Specifies the connection handle to the data source returned by SQLCONNECT( ).

Remarks

Use SQLCOMMIT( ) to commit a transaction. SQLCOMMIT( ) returns 1 if the transaction is successfully committed; otherwise, it returns -1. If SQLCOMMIT( ) returns -1, you can use AERROR( ) to determine why the transaction could not be committed.

If manual transactions are in effect (the SQLSETPROP( ) Transactions property is set to Manual), you can send multiple updates to remote tables and commit all the updates with SQLCOMMIT( ).

Updates can be rolled back with SQLROLLBACK( ).