Allows a free table or free cursor to support transactions.
MAKETRANSACTABLE([nWorkArea | cAlias])
- Specifies the work area of the table or cursor for which transactions will be supported.
- Specifies the alias of the table or cursor for which transactions will be supported.
Logical. Returns a logical true (.T.) if MAKETRANSACTABLE(В ) was able to make the free table or cursor support transactions, otherwise a logical false (.F.) is returned.
When MAKETRANSACTABLE(В ) is used to make a free table or free cursor support transactions, you can use the BEGIN TRANSACTION, END TRANSACTION, and ROLLBACK commands for the free table or free cursor. Use the ISTRANSACTABLE(В ) function to determine if a free table or free cursor supports transactions.
|When MAKETRANSACTABLE(В ) is used to make a free table or free cursor support transactions, the free table or free cursor supports transactions in all work areas and data sessions in which it is opened. MAKETRANSACTABLE(В ) makes all open instances of a free table or free cursor support transactions, including those in other data sessions within a single instance of VFP.|
If a free table that does not support transactions is open in more than one data session, the free table cannot be made to support transactions. However, you can open a free table that already supports transactions in additional data sessions.
If row buffering is enabled, then a table update is performed if the free table or free cursor has pending changes before the free table or free cursor is made to support transactions. You cannot use MAKETRANSACTABLE(В ) to enable transactions for a free table that has table buffering enabled.
To disable transactions for a free table, you must close the free table in all data sessions.