SORTED BY Sorts the members of the set produced by the main command. Syntax SORTED BY «expression [ASCENDING|DESCENDING]» Parameters expression An expression that identifies a field to be used as a sort key. Complex expressions must be enclosed in parentheses. ASCENDING or DESCENDING Specifies how the sort on the associated key is to be performed.…
Read more
UNRELATED In a set specification, selects non-matching members of an EntitySet, a relationship with fields, an application document, or a result set. Syntax object (UNRELATED) Parameters object The name of an EntitySet, a relationship with fields, a form, a structured application document, or a set. Can be a role name for an EntitySet or relationship…
Read more
Indicates the reason that a deadlock condition occurred. Syntax $deadlockreason Return Value A character string. Cannot be reset by an application program. Description $DeadlockReason contains one of the following reason codes for the current deadlock condition: Code Reason 0 transaction completed normally 1 transaction terminated due to time out 2 transaction terminated due to transaction…
Read more
A “null” value for comparison. Syntax $null Value “Null” (a state of valuelessness). Cannot be reset by an application program. Description The “null” property. $Null can be written without the dollar sign. When certain atomic expressions (variable name, field name, form field name, or formal parameter name) are used before being assigned values, or if…
Read more
Checks a value to see if it is $Null. Syntax expression IS [NOT] $NULL Parameters expression Any expression. Return Value Logical. Comments An IS $NULL comparison is logically true if expression is valueless (unassigned). If expression has been assigned any value (including the null string), then the comparison is logically false. An IS NOT $NULL…
Read more
Controls the evaluation of other expressions. Syntax expression1 WHERE expression2 Parameters expression1 A value expression. expression2 A logic expression using conditional and Boolean operators. Return Value If expression2 is logically true, the value of expression1; otherwise, $Null. Example let i = { 1 where Age < 10, 2 where Age between 10 and 30, 4 where…
Read more
Matches an expression to a pattern. Syntax expression [NOT] LIKE pattern Parameters expression An expression that evaluates to a character string. pattern An expression that evaluates to a character string. Pattern must consist of combinations of letters, digits, symbols, and the special wildcard characters % and _. Return Value Logical. Comments A LIKE comparison is…
Read more
Compares one value to a list of values. Syntax expression [NOT] IN («expr») Parameters expression An expression that evaluates to either a number or a character string. expr A list of expressions whose values are to be compared to expression. Members of the list are separated from one another by commas. Return Value Logical Comments…
Read more
English 
Portuguese