Skip to main content
Version: Next

Queries

DESCRIBE QUERY EXECUTION ( status : Boolean )
Find in field ( targetField : Field ; value : Field, Variable ) : Integer
GET QUERY DESTINATION ( destinationType : Integer ; destinationObject : Text ; destinationPtr : Pointer )
Get query limit : Integer
Last query path ( descFormat : Integer ) : Text
Last query plan ( descFormat : Integer ) : Text
ORDER BY ( {aTable : Table} {; ...(aField : Field {; order : >, <}) } {; *} )
ORDER BY ATTRIBUTE ( {aTable : Table ;} {; ...(objectField : Field ; attributePath : Text {; order : >, <})} {; *} )
*ORDER BY FORMULA ( aTable : Table ; { ...(formula : Expression {; order : >, <})} )
QUERY ( aTable : Table {; queryArgument : Expression {; *}} )
QUERY ( queryArgument : Expression {; *} )

[QUERY BY ATTRIBUTE ( {aTable : Table}{;}{conjOp : &,
QUERY BY EXAMPLE ( {aTable : Table} {; *} )
QUERY BY FORMULA ( aTable : Table {; queryFormula : Expression} )
QUERY SELECTION ( aTable : Table {; queryArgument : Expression {; *} )
QUERY SELECTION ( queryArgument : Expression {; *} )

[QUERY SELECTION BY ATTRIBUTE ( {aTable : Table}{;}{conjOp : Operator ;} objectField : Field ; attributePath : Text ; queryOp : Text, >, <, >=, <=, #, =,
QUERY SELECTION BY FORMULA ( aTable : Table {; queryFormula : Expression} )
QUERY SELECTION WITH ARRAY ( targetField : Field ; array : Array )
QUERY WITH ARRAY ( targetField : Field ; array : Array )
SET QUERY AND LOCK ( lock : Boolean )
SET QUERY DESTINATION ( destinationType : Integer {; destinationObject : Text, Variable {; destinationPtr : Pointer}} )
SET QUERY LIMIT ( limit : Integer )