How Do I delete all the record from a table

Eddy_Bailey

I have created a table that will hold non-financial data. From time to time I need to dump this data. How can I do this easly? In Code, or automated.

DenSter

Open the table, select all, and press the delete key.

Savatage

Sounds pretty easy

SPost29

In code you may want to create a button on a setup table or a menu choice under periodic activities and do something like

set some filters (to limit what is deleted maybe by date older than some date)
use a confirm dialog (are you sure you want to delete X ?)

table.deleteall;

You may not want your end users opening the object designer and knowing they can delete records

DenSter

You can also open the list form, select all, and press delete. Works just as well . Of course the list form has to allow the user to delete records.

Eddy_Bailey

Thank you. Actually I got a code unit to do this for me independent of the user. Thanks.