SQL_ROLLBACK_STMT¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

Rolls back an SQL transaction, any data changes inside the transaction will not be committed by the server.

Syntax

SQL_ROLLBACK_STMT

Example

SQL_START_TRANSACTION_STMT
SQL_SET_STMT to "DELETE FROM CUSTOMER WHERE ID = 2145"
SQL_PREPARE_STMT
SQL_EXECUTE_STMT
If (Err) Begin
    SQL_ERROR_MESSAGE errorString
    Showln errorString
    SQL_ROLLBACK_STMT
End
Else
    Showln "SQL Statement successful - committing"
    SQL_COMMIT_STMT

SQL_START_TRANSACTION_STMT
SQL_COMMIT_STMT