ZAP Command

Removes all records from a table or cursor.

Syntax

ZAP

Remarks

When SET SAFETY is ON, the user is prompted whether the table should be truncated.

Compatibility

Windows Mobile: The Microsoft device emulator does not properly handle changing the file size when the file was originally larger. Therefore the ZAP command does not physically change the file size of a table. It does, however, change the record count in the table header. As far as Guineu is concerned, the table is empty afterwards. Microsoft Visual FoxPro will report an error, though, when you open the table with SET TABLEVALIDATE set to a value different from 0.

This happens only on a simulated Storage Card. ZAP works properly if you copy your program from the Storage Card into the \Program Files folder and run it from there.

See also

SET SAFETY