Difference between revisions of "ROLLBACK()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to verify success of a transaction rollback | Function to verify success of a transaction rollback | ||
| − | |||
==Syntax== | ==Syntax== | ||
ROLLBACK() | ROLLBACK() | ||
| − | |||
==See Also== | ==See Also== | ||
[[BEGIN TRANSACTION]], [[COMPLETED()]], [[ISMARKED()]], [[RESET IN]], [[ROLLBACK]], [[END TRANSACTION]], [[SET ROLLBACK]] | [[BEGIN TRANSACTION]], [[COMPLETED()]], [[ISMARKED()]], [[RESET IN]], [[ROLLBACK]], [[END TRANSACTION]], [[SET ROLLBACK]] | ||
| − | |||
==Description== | ==Description== | ||
The ROLLBACK() function returns .T. if a rollback is successful and .F. if a rollback fails. This function is used in conjunction with the ROLLBACK command to determine if an attempted rollback and recovery was successful. Automatic rollback and recovery can be initiated within a BEGIN TRANSACTION...END TRANSACTION block with the SET ROLLBACK ON command. | The ROLLBACK() function returns .T. if a rollback is successful and .F. if a rollback fails. This function is used in conjunction with the ROLLBACK command to determine if an attempted rollback and recovery was successful. Automatic rollback and recovery can be initiated within a BEGIN TRANSACTION...END TRANSACTION block with the SET ROLLBACK ON command. | ||
| − | |||
==Example== | ==Example== | ||
| Line 39: | Line 35: | ||
endif | endif | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 10:25, 12 December 2012
Purpose
Function to verify success of a transaction rollback
Syntax
ROLLBACK()
See Also
BEGIN TRANSACTION, COMPLETED(), ISMARKED(), RESET IN, ROLLBACK, END TRANSACTION, SET ROLLBACK
Description
The ROLLBACK() function returns .T. if a rollback is successful and .F. if a rollback fails. This function is used in conjunction with the ROLLBACK command to determine if an attempted rollback and recovery was successful. Automatic rollback and recovery can be initiated within a BEGIN TRANSACTION...END TRANSACTION block with the SET ROLLBACK ON command.
Example
procedure recovery rollback if rollback() dialog box "Rollback was ok" else dialog box "Rollback not completed" endif return use masterfile on error do recovery begin transaction delete first 15 replace all t1 with (t2*t3)/100 list end transaction if completed() dialog box "Transaction completed" else dialog box "Errors occurred during transaction" endif
Products
Lianja, Lianja Server
