transaction statement

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

transaction statement

Syntax

Parameter(s)

Description

Example(s)

See also