| 20% Command group | 20% Flag affected | 20% Reversible | 20% Execute on client | 20% Platform(s) |
|---|---|---|---|---|
| Finding data | NO | NO | NO | All |
Clear find table
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.
# 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