The transaction statement enables or disables participation in a transaction.
Syntax
transaction [on|off|exp] |
Parameter(s)
on |
Enables participation in a transaction. |
off |
Disables participation in a transaction. |
exp |
Transaction is turned on if the expression evaluates to nonzero (true) and turned off if it evaluates to 0 (false). |
Description
CAUTION |
This function should not be used directly in the context of a user-written FlashBASIC or BASIC program as it allows violating the theoretical structure of a transaction. |
This functionality is intended for languages built on top of FlashBASIC or BASIC (like some SQL engines or 4GLs) that need to use temporary files for internal reasons without affecting a user-level transaction.
The term on or off is required if an expression is used with this function.
Example(s)
transaction start transaction cache off transaction off else msg="8 off"; goto fail write "1" on "1" read xx from "1" else msg="8 read"; goto fail x=1 transaction onoff x else msg="8 onoff"; goto fail write 1 on 2 read xx from 2 then msg="8 read2"; goto fail transaction commit read xx from 2 else msg="8 read3"; goto fail delete 1 delete 2 |
See Also