OdbcRollbackTrans

Syntax

ODBCRollbackTrans(str_dbidentifier);

str_dbidentifier

The identifier specified in OdbcConnect.

Description

Rolls back and ends a transaction that you have opened with ODBCBeginTrans.

Note:

This function cannot be run in the preprocessing phase, and must therefore be inside an if (preproc() == 0) { } block.

Returns

	The transaction was successfully rolled back.
-1	Error. Problems occurred while trying to roll back the transaction.

Example

if (PreProc() == 0)
{
ODBCBeginTrans("TEST");
$st="UPDATE TEST.dbo.myTable SET col1 = N'1121'; ";
OdbcExecute("TEST",$st);
ODBCRollbackTrans("TEST");
}