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.19
Syntax FUNCTION MakeTransactable(
uArea
) AS LOGIC CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public static bool MakeTransactable(
Usual uArea = default
)
Request Example
View SourceParameters
- 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:
Logic
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.
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.
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 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.
See Also