Clear find table

Syntax

Clear find table

Description

This command clears the find table for the current main file and releases the memory it used.

When a Find, Next or Previous command is encountered, Omnis uses the Index, Search and Sort field parameters to create a table of records (similar to a SQL Select table). This may simply be an existing index in which case no further processing takes place or, if there is a search and/or sort condition, a file may be scanned and a selection of records sorted in memory. If a Next or Previous returns an unexpected record or no record, this is probably because there is still a find table in existence from another Find operation.

For a large file, a substantial amount of RAM may be used.

Example

# Clear the find table after the first overdrawn account is found
Set main file {fAccounts}
Set search as calculation {fAccounts.Balance<0}
Find first on fAccounts.Code (Use search)
Clear find table