17. Forms Statements : purgetable Statement—Purge Deleted Rows
 
Share this page                  
purgetable Statement—Purge Deleted Rows
This statement throws away the list of deleted rows from a table field's data set.
Syntax
purgetable [formname] [tablename]
Description
The purgetable statement removes any deleted rows from the deleted list of a table field's data set so that the memory held by these rows can be reused. The purgetable statement can only be used on table fields that have been initialized with the inittable statement. If there are no rows in the deleted list when a purgetable statement is issued no operation occurs, but time is wasted checking the list, and so unnecessary purgetable statements must be avoided.
Formname must identify a declared form (see the addform or forminit statement descriptions). You can specify formname and tablename using a quoted or unquoted character string literal or program variable. The formname must be the name of the form containing the specified table field. If formname evaluates to an empty string then the current form is assumed. Similarly, if tablename evaluates to an empty string then the current field is assumed to be the table field to be cleared. If the current field is not a table field then a runtime error results.
Examples—purgetable statement:
Example 1:
Clear the rows marked for deletion in the data set of the table field employee on the form empform.
exec frs purgetable empform employee
Example 2:
Clear the rows marked for deletion in the data set of the table field departments on the current form.
exec frs purgetable ' ' departments
Example 3:
Clear the rows marked for deletion in the data set of the table field contained in the program variable whichtable, on the current form.
exec frs purgetable ' ':whichtable