MakeTransactable Function |  |
-- todo --
Allows a free table or free cursor to support transactions.
Namespace: XSharp.VFP
Assembly: XSharp.VFP (in XSharp.VFP.dll) Version: 2.21
SyntaxRequest Example
View Source
Logical. Returns a logical true (.T.) if MakeTrancsactable( ) was able to make the free table or cursor support transactions, otherwise a logical false (.F.) is returned.
Parameters
- uArea (Optional)
- Type: Usual
Specifies the work area of the table or cursor for which transactions will be supported.
Or
Specifies the alias of the table or cursor for which transactions will be supported.
Return Value
Type: LogicLogical. Returns a logical true (.T.) if MakeTrancsactable( ) was able to make the free table or cursor support transactions, otherwise a logical false (.F.) is returned.
Remarks
A free table is a table that has not been added to a database with the ADD Table Command. A free cursor is a cursor that is created from a
free table or with the Create CURSOR - SQL Command.
When MakeTrancsactable( ) 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 IsTrancsactable( ) function to determine if a free table or free cursor supports transactions.
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 MakeTrancsactable( ) 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.
When MakeTrancsactable( ) 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 IsTrancsactable( ) function to determine if a free table or free cursor supports transactions.
 Note |
|---|
| When MakeTrancsactable( ) 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. MakeTrancsactable( ) makes all open instances of a free table or free cursor support transactions, including those in other data sessions within a single instance of X#. |
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 MakeTrancsactable( ) 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.
See Also