Set search as calculation

Command group Flag affected Reversible Execute on client Platform(s)
Searches NO YES NO All

Syntax

Set search as calculation {calculation}

Description

This command sets the current search as the single line calculation specified. The calculation replaces the current search class if one has been set. A subsequent report, Search list or a Find command with Use search will use the search calculation.

Search calculations allow the index optimization routine in Omnis to select a suitable index, provided that such an index is available. Leaving the calculation blank has the effect of clearing the previous search calculation.

Example

# Use Town index in fCustomers to find Londoners and then use search to locate Smiths.
Set main file {fCustomers}
Set search as calculation {fCustomers.Surname='Smith'}
Find on fCustomers.Town (Exact match,Use search) {'London'}
Do $cwind.$redraw() 

# example 2, moves selected lines only between lists
Set current list lList2
Set search as calculation {#LSEL}
Merge list lList1 (Use search)