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.