Transaction

The Transaction function controls PSQL transaction processing within an application. It may be used to begin, end, or abort a PSQL transaction.

object.Transaction iOperationCode


Part	Description
object	Required. The object placeholder represents an object expression that evaluates to an object in the Applies To list. Note: This placeholder is simply a requirement of ActiveX architecture, and does not limit the scope of the transaction to the file attached to object. Any inserts, updates, or deletes to any files nested between the begin and end transaction methods will be included in the transaction.
iOperationCode	Required. Specifies the transaction operation to perform.

The following operations are supported by the Transaction method. Any operation codes not listed here will return a Status Code 1, invalid operation.


Code	Constant	Description
19	BTO_BeginTransaction	Begins an exclusive transaction - no other processes may access the files involved in the transaction until the transaction completes.
20	BTO_EndTransaction	Ends the transaction and commits changes which have been made to files since the transaction was begun.
21	BTO_AbortTransaction	Aborts all changes to files made since the Begin Transaction operation and ends the transaction.
1019	BTO_BeginTransaction + 1000	Begins a concurrent transaction (Pervasive.SQL version 6 or above— previous versions will return Status Code 1) Other processes may access the files affected by the transaction.