Getting Started

Searching

See also: Extended Search
 

Searches for records using specific criteria (filtering them out of a very large collection).

Search criterias can be provided for every data field. If you are searching multiple data fields, the criteria should be linked with a logical AND. The maximum length of a search key is 256 characters.

When the SEARCH function is invoked, the search window appears.

Search criteria for a single data field can be linked with AND or OR.

Search criterias for a single data field that contains spaces, must be enclosed in single quotes.

 
Logical Operators:
& logical AND Spaces required before and after!!
| logical OR
Replacement Characters (Wildcards):
% Wildcard, matches any character string No spaces allowed before or after!!
? Wildcard, matches any single character
Binary Operators for Strings (letters and numbers):
< > not equal No spaces allowed before or after!!
> collates higher than > = collates higher or equal 
< collates lower than < = collates lower or equal
Binary Operators for Integers, Real Numbers, Currencies, Dates:
< > not equal No spaces allowed before or after!!
> numerically larger > = numerically larger or  equal
< numerically smaller < = numerically smaller or equal
Clear All Search Criteria for a Line:
SHIFT +
Delete a Search Criterion:
Numeric Keypad
 

Modify Search Priority

+ "O" This key-combination can be used in search mode to change the priority of the sorting sequence of the columns.

New values can be entered in the window that opens (minus-sign means sort in decreasing order)

After entering the search criteria and pressing the ENTER key (or the right mouse button), the following menu will appear:

 
 

Fetch:

Obtains the records matching the entered search criteria.

Count:

Indicates how many records were found which match the entered search criteria.

Quit:

Exits search mode without starting a search.

If a sorting priority was entered before the sort, and if the number of records found is greater than the maximum value specified in the mask, the additional records can be loaded using the scan buttons: 

Each time, 100 records are loaded for viewing, and they can also be sorted. That sort involves the current 100 records, and not all the records found!