DBDelete Action

Deletes the current record from a Recordset.

Use

The DBDelete action sets the EditMode property of the recordset to EditNone if it is successful.

Retrieving field values from the deleted record returns an error value. After deleting the current record, the deleted record remains current until you move to a different record. Once you move away from the deleted record, it is no longer accessible.

If you nest deletions in a transaction, you can recover deleted records with the RollbackTrans action.

Parameters

Recordset - (Required)

Specifies the name of the Recordset object from which the current record should be deleted.

Notes

Using the DBConnect action establishes the physical connection to a data source. After this action successfully completes, the connection is live and you can issue commands against it and process the results.

When you have concluded your operations over an open Connection, use the DBClose action to terminate the connection and free any associated system resources.

DBDelete Action

Use

Parameters

Notes

See Also