UseTransactions Property

  • Article

Specifies if the CursorAdapter uses transactions when sending Insert, Update or Delete commands through ADO or ODBC. Read/write at design time and run time.

CursorAdapter.UseTransactions[ = lExpr]

Return Value

  • lExpr
    The settings for the UseTransactions property are:

    Setting Description

    True (.T.)

    (Default) The CursorAdapter uses transactions when sending Insert, Update or Delete commands through ADO or ODBC.

    False (.F.)

    The CursorAdapter doesn't use transactions when sending Insert, Update or Delete commands through ADO or ODBC.

Remarks

Applies To: CursorAdapter Class.

The CursorAdapter object relies on ADO and ODBC APIs to manage transactions. If you ignore API recommendations and send specific transaction commands directly to an ADO or ODBC backend, you may want to set the UseTransactions property to False (.F.) to prevent undesirable transaction interaction.

See Also

Reference

BEGIN TRANSACTION Command
END TRANSACTION Command
ROLLBACK Command