The delete statement removes rows from a database table, based on the conditions specified in the where clause. If no condition is specified, the statement deletes all the rows in the table. The statement below deletes any row of the Personnel table that contains the same value in the empno column as in the form's field Empno.

To remove values from a database table using a table field in this way, use the delete statement along with the unloadtable statement, as described in Processing an Entire Table Field or Array with Unloadtable and unloadtable Statement--Loop Through Rows and Execute Statements on page 184.