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

See Also

begin work Statement

_CP_trans