Cancels any changes made during the current transaction.
Syntax
SQLROLLBACK(nConnectionHandle)
Returns
Numeric
Arguments
nConnectionHandle
Specifies the connection handle to the data source returned by SQLCONNECT( ).
Remarks
SQLROLLBACK( ) returns 1 if the transaction is successfully rolled back; otherwise, it returns -1. If SQLROLLBACK( ) returns -1, you can use AERROR( ) to determine why the transaction could not be rolled back.
If manual transactions are in effect (the SQLSETPROP( ) transaction property is set to manual), you can send multiple updates to remote tables. The updates can all be rolled back with SQLROLLBACK( ).
Updates can be committed with SQLCOMMIT( ).