Difference between revisions of "COMPLETED()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to determine whether an error occurred during a multi-statement transaction | Function to determine whether an error occurred during a multi-statement transaction | ||
| − | |||
==Syntax== | ==Syntax== | ||
COMPLETED() | COMPLETED() | ||
| − | |||
==See Also== | ==See Also== | ||
[[BEGIN TRANSACTION]], [[END TRANSACTION]], [[ISMARKED()]], [[RESET IN]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]] | [[BEGIN TRANSACTION]], [[END TRANSACTION]], [[ISMARKED()]], [[RESET IN]], [[ROLLBACK]], [[ROLLBACK()]], [[SET ROLLBACK]] | ||
| − | |||
==Description== | ==Description== | ||
The COMPLETED() function returns .T. if no errors occurred during processing of any command issued between the BEGIN TRANSACTION and END TRANSACTION commands. | The COMPLETED() function returns .T. if no errors occurred during processing of any command issued between the BEGIN TRANSACTION and END TRANSACTION commands. | ||
| − | |||
==Example== | ==Example== | ||
| Line 41: | Line 37: | ||
endif | endif | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 11:32, 11 December 2012
Purpose
Function to determine whether an error occurred during a multi-statement transaction
Syntax
COMPLETED()
See Also
BEGIN TRANSACTION, END TRANSACTION, ISMARKED(), RESET IN, ROLLBACK, ROLLBACK(), SET ROLLBACK
Description
The COMPLETED() function returns .T. if no errors occurred during processing of any command issued between the BEGIN TRANSACTION and END TRANSACTION commands.
Example
procedure recovery rollback if rollback() dialog box "Rollback was ok." else dialog box "Rollback failed." endif return use setcomm on error do recovery begin transaction reset in comm_2 delete first 15 insert replace all t1 with (t2*t3)/100 list end transaction if completed() dialog box "Transaction completed OK else dialog box "Errors occurred during transaction" endif
Products
Lianja Server, Lianja
