Skip to main content
Version: Next

QUERY SELECTION BY FORMULA

QUERY SELECTION BY FORMULA ( aTable {; queryFormula} )

ParameterTypeDescription
aTableTable🡒Table for which to return a selection of records
queryFormulaBoolean🡒Query formula

Description

QUERY SELECTION BY FORMULA looks for records in aTable. QUERY SELECTION BY FORMULA changes the current selection of aTable for the current process and makes the first record of the new selection the current record.

QUERY SELECTION BY FORMULA performs the same actions as QUERY BY FORMULA. The difference between the two commands is the scope of the query:

  • QUERY BY FORMULA looks for records among all the records in the table.
  • QUERY SELECTION BY FORMULA looks for records among the records currently selected in the table.

For more information, see the description of the QUERY BY FORMULA command.

See also

QUERY
QUERY BY FORMULA
QUERY SELECTION