Difference between revisions of "ROLLBACK()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to verify success of a transaction rollback | Function to verify success of a transaction rollback | ||
| Line 12: | Line 8: | ||
==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]] |
| Line 46: | Line 42: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Transaction Processing]] | [[Category:Transaction Processing]] | ||
[[Category:Transaction Processing Functions]] | [[Category:Transaction Processing Functions]] | ||
Latest revision as of 15:18, 7 December 2009
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
Recital, Recital Server
