Version: 21 R4 BETA

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 : &, \|, # ;} objectField : Field ; attributePath : Text ; queryOp : Text,>, <,>=, <=, #, =, \|, % ; value : Text, Real, Date, Time {; *} )
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 : &, \|, # ;} objectField : Field ; attributePath : Text ; queryOp : Text,>, <,>=, <=, #, =, \|, % ; value : Text, Real, Date, Time {; *} )
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 )