Contents - Index


$ClearLookup

 

The $ClearLookup directive is available in the Professional version.  It will clear data from the specified Lookup table with the option to specify the rows and/or columns that are to be cleared. 

 

The format of the $ClearLookup directive is

 

$ClearLookup  'LookupTableName'   /C2..5  /R1..10

 

'LookupTableName' is a string constant or string variable that provides the name of the Lookup table as it appears on the tab of the Lookup Table window

 

The /C and  /R are optional parameters.  

 

/C specify a range of columns, e.g., 1..10 that will be cleared.   A string variable can be used to provide the range, e.g., /CC$ where C$ contains the range.  If the range is not specified, then all columns in the table will be cleared for the specified range of columns.

 

/R specify a range of rows, e.g., 2..5 that will be cleared.   A string variable can be used to provide the range, e.g., /RR$ where R$ contains the range.  If the range is not specified, then all rows in the table will be cleared for the specified range of columns.  

 

The $ClearLookup directive is executed while the equations are being compiled, before the calculations are initiated.  Multiple $ClearLookup directives may be used.

 

See also:  $CopytoLookup

 

Directives