Commands and Topics for Queries
DESCRIBE QUERY EXECUTION
(status)
Find in field
(targetField; value)
Longint
Get Last Query Path
(descFormat)
String
Get Last Query Plan
(descFormat)
String
ORDER BY
({aTable}{; aField{; > or <{; aField2; > or <2; ...; aFieldN; > or <N}{; *}}})
ORDER BY FORMULA
(aTable{; expression{; > or <}}{; expression2; > or <2; ...; expressionN; > or <N})
QUERY
({aTable}{; queryArgument{; *}})
QUERY BY EXAMPLE
({aTable}{; }{*})
QUERY BY FORMULA
({aTable}{; }{queryFormula})
QUERY SELECTION
({aTable}{; queryArgument{; *}})
QUERY SELECTION BY FORMULA
(aTable{; queryFormula})
QUERY SELECTION WITH ARRAY
(targetField; array)
QUERY WITH ARRAY
(targetField; array)
SET QUERY AND LOCK
(lock)
SET QUERY DESTINATION
(destinationType{; destinationObject})
SET QUERY LIMIT
(limit)
Other related commands:
Operators
--
Theme:
Operators
QUERY BY SQL
({aTable; }sqlFormula) --
Theme:
SQL