Programmable Searching

This page is currently incomplete, but you can find information about this topic at the links below:

- checkemptyselection -- The checkemptyselection statement notifies the user if a selection failed, and reverts to the previous selection.
- find -- The find statement locates the first visible record in the active database for which the specified condition is true.
- findabove -- The findabove statement locates the next previous record (above the current record) in the active database for which the specified condition is true.
- findbackwards -- The findbackwards statement locates the last visible record in the active database for which the specified condition is true.
- findbelow -- The findbelow statement locates the next visible record (below the current record) in the active database for which the specified condition is true.
- findid -- The findid statement locates a record in the active database by its ID number (see info("serverrecordid").
- findnth -- The findnth statement finds the nth (2nd, 3rd, 4th, etc.) record that matches a true-false test.
- findselectdialog -- The findselectdialog statement opens the standard Find/Select dialog.
- Handling Empty Selections in Code -- dealing with an empty selection data set.
- ifselect -- The ifselect statement combines the select and if info("empty") operations into a single statement.
- info("searchformula") -- The info("searchformula") function returns the most recent search formula used in a find statement, if any.
- info("selectduplicatesortwarning") -- The info("selectduplicatesortwarning") function works with the selectduplicatesnowarning statement to ascertain whether or not the database was sorted correctly when last search for duplicates was performed.
- nextmatch -- The nextmatch statement locates the next visible record in the active database for which the condition specified in the most recent Find statement is true.
- pleaseselectall -- The pleaseselectall statement makes sure that all records are selected.
- previousmatch -- The previousmatch statement locates the previous (closer to the top) visible record in the active database for which the condition specified in the most recent Find statement is true.
- removeselected -- The removeselected statement deletes all selected records from the database.
- removeunselected -- The removeunselected statement deletes all unselected records from the database.
- select -- The select statement makes visible only those records for the active database for which the specified condition is true.
- selectadditional -- The selectadditional statement adds unselected records to a previously selected group if they match the true-false test.
- selectall -- The selectall statement makes every record in the database visible.
- selectduplicates -- The selectduplicates statement selects records containing duplicate information in the database.
- selectduplicatesnowarning -- The selectduplicatesnowarning statement selects records containing duplicate information in the database.
- selectreverse -- The selectreverse statement makes every visible record invisible, and every invisible record visible.
- selectwithin -- The selectwithin statement uses a Boolean formula to exclude records from a previously selected group.
- selectzipdistancetool -- The selectzipdistancetool statement selects records near the current record, based on zip codes.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, with some updates.