Delete Rows dialog box

Delete rows (rows) of the current table or rowset. Click a radio button to choose the scope of the deletion.

Dialog box options

Current

Deletes only the current row (displayed on the form).

Specified

Deletes the row or rows that match the specified condition you type in the box. The condition is in the form of a condition in the WHERE clause of an SQL SELECT statement. For example:

"Length CM" < 40

will delete all rows where the "Length CM" field contains a value less than 40. (Double quotes are required around field names that contain spaces. Strings and dates are enclosed in single quotes.)

All

Deletes all rows in the current table or rowset.

How to get there: In Table Run mode, choose Table|Delete Rows.