DELETE command

Used to delete ACL project items, fields from table layouts, variables, table history entries, relations between tables, and physical files in Windows folders. Also used to remove columns from views.

Syntax

Purpose

Syntax

To delete an ACL project item

DELETE item_type item_name <OK>

To delete all record notes, and the auto-generated RecordNote field, from the open table

DELETE NOTES <OK>

To delete a field from a table layout

DELETE field_name <OK>

To remove a column from a view

DELETE COLUMN view_name column_name <ALL> <OK>

To delete a variable or all variables

DELETE {variable_name|ALL} <OK>

To delete the history for the current ACL table

DELETE HISTORY retain_history_entries <OK>

To delete a relation between two tables

DELETE RELATION <child_table_name|relation_name> <OK>

To delete a file

DELETE file_name <OK>

Parameters

item_type

Specify one of the following ACL project item types:

  • FOLDER – Deletes the specified project folder.

  • FORMAT – Deletes the specified table layout, all its views, and its associated indexes and relations. Any other table layouts for the associated table are retained. The data file (.fil) is not deleted unless the Delete Data File with Table checkbox is selected in the Table tab in the Options dialog box (Tools > Options).

  • REPORT – Deletes the specified view.

  • SCRIPT or BATCH – Deletes the specified script.

  • WORKSPACE – Deletes the specified workspace.

  • VIEW – Deletes the specified view.

  • INDEX – Deletes the specified index.

  • NOTES – Deletes all record notes from the open table, and the RecordNote field from the table layout.

item_name

Specifies the name of the ACL project item to delete.

field_name

Specify a field name in the current ACL table layout.

view_name

Specifies the name of the view to remove the column from.

column_name

Specifies the name of the column to remove.

ALL

Specifies that if the column occurs more than once in the view, all instances will be removed. If there is more than one instance of the column, and the ALL parameter is not specified, the leftmost instance of the column is removed.

variable_name|ALL

Specify the variable name to delete or ALL to delete all variables.

HISTORY retain_history_entries

Specifies that all of the table history entries will be deleted except for the number of most recent entries specified by the retain_history_entries parameter.

RELATION <child_table_name|relation_name>

Deletes any relation that has no dependent relations and no related fields referenced in either the active view or in an active computed field. The child_table_name or relation_name qualifier specifies which relation to delete. Use the relation_name qualifier if the relation was specifically named when it was created. Otherwise, use the child_table_name, which is the default relation name when a relation is created. If you do not add this qualifier, ACL deletes the last relation defined.

file_name

Specify the name of a physical file. You can specify an absolute or relative path to a file you want to delete. If the path has spaces, enclose it in double quotation marks.

OK

Optional. Specifies that the confirmation dialog box is suppressed.

Remarks

You can delete a field from a table layout even if the field is included in the current view. You cannot delete a field or variable referenced by a computed field unless you first delete the computed field.

You cannot delete a view if it is currently active.

Example

In the following example, the “Date” field is deleted from the table layout associated with the “Ar” table.

DELETE Date

In the following example, two columns are removed from the “AR_Report” view associated with the “Ar” table. The OK parameter is used with both DELETE commands so that no confirmation prompt is displayed when the script runs.

OPEN Ar
DELETE COLUMN AR_Report Date OK
DELETE COLUMN AR_Report Invoice_Date OK


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback