Difference between revisions of "ROLLBACK()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Transaction Processing | Transaction Processing | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[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 | + | 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. |
| Line 25: | Line 22: | ||
<code lang="recital"> | <code lang="recital"> | ||
procedure recovery | procedure recovery | ||
| − | rollback | + | rollback |
| − | if rollback() | + | if rollback() |
| − | dialog box "Rollback was ok" | + | dialog box "Rollback was ok" |
| − | else | + | else |
| − | dialog box "Rollback not completed" | + | dialog box "Rollback not completed" |
| − | endif | + | endif |
return | return | ||
| Line 36: | Line 33: | ||
on error do recovery | on error do recovery | ||
begin transaction | begin transaction | ||
| − | delete first 15 | + | delete first 15 |
| − | replace all t1 with (t2*t3)/100 | + | replace all t1 with (t2*t3)/100 |
| − | list | + | list |
end transaction | end transaction | ||
if completed() | if completed() | ||
| − | dialog box "Transaction completed" | + | dialog box "Transaction completed" |
| − | else | + | else |
| − | dialog box "Errors occurred during transaction" | + | dialog box "Errors occurred during transaction" |
endif | endif | ||
</code> | </code> | ||
| Line 52: | Line 49: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Transaction Processing]] | ||
| + | [[Category:Transaction Processing Functions]] | ||
Revision as of 14:03, 2 June 2009
Class
Transaction Processing
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 Database Server, Recital Mirage Server, Recital Terminal Developer
