D Delete

Delete existing record or row.

Modes

None.

Conditions

  • The table for which the Delete is requested is open.

  • The previous call to the connector was a Fetch mode 2 which completed successfully. (This is only relevant to DBMSs such as ISAM.)

Description

For SQL-like DBMSs, the connector identifies exactly one record by either the primary key or the physical record address.

For ISAM-like or record-level DBMSs, a Fetch (mode 2) will already have been issued to position on and lock the record. The positioned record is the record which is deleted.

Related Topics