Specifies the current text delimiter for comma-delimited format. Syntax SET TEXTDELIMITER character Parameters character Any valid character, or a variable containing a valid character. Reserved characters (e.g., space, backslash, etc.) must be enclosed in quotation marks. Comments The TEXTDELIMITER option is set to the double quotation mark (“) by default. The specified character is used…
Read more
Sorts the members of an existing result set. Syntax SORT [setname>] BY expression [ASCENDING|DESCENDING] Parameters setname The name of a result set. If setname is not specified, the current set is used. expression An expression that identifies a field to be used as a sort key. Complex expressions must be enclosed in parentheses. ASCENDING or…
Read more
Performs a bit-wise OR of two values. Syntax $or(char1,char2) Parameters char1 a character string, or an expression that evaluates to a character string char2 a character string, or an expression that evaluates to a character string Return Value Character string. Comments The $or function combines the bit patterns of two characters in the fashion of…
Read more
Controls the way Automatic Sequence Numbers operate. Syntax SET SEQUENCENUMBER {object | ALL} {number | variable | ON | OFF}. where object The name of an Entity-Set Relationship with fields that contains an ASN defined ALL Refer to all Entity-Sets and Relationships with fields that contain ASNs defined number a positive number from 1 up…
Read more
Executes server-side functions. Syntax $serverfunction (server specific syntax [«,parameters»]) Parameters server specific syntax A character string or an expression that evaluates to a character string containing a server-specific syntax for execution on the server side. parameters Zero or more expressions to satisfy the usage of the server-specific syntax. Return Value A value created by the…
Read more
Performs a bit-wise AND of two values. Syntax $and(char1,char2) Parameters char1 a character string, or an expression that evaluates to a character string char2 a character string, or an expression that evaluates to a character string Return Value Character string. Comments The $and function combines the bit patterns of two characters in the fashion of…
Read more
Specifies the current output. Syntax SET OUTPUT docname [APPEND] [FILEPATH file://<file full path>] Parameters docname The name of the application document to which all output is to be sent. Can also be one of the two pre-defined application documents, terminal or printer. APPEND Specifies that new output to docname is to be appended to the…
Read more
KEEP Keeps (retains) some components in a result set while discarding others. Syntax KEEP «component» Parameters component The name of a component found among the objects declared in a set specification. Any number of components can be specified, provided they appear among the declared objects. Comments In certain instances, you want to select records from…
Read more
Calculates a time value by adding ticks to (or subtracting ticks from) a specified time value. Syntax $addticks(time,number) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, that expresses a valid time value in the format HHMMSSTT number a number, or an expression that evaluates to a number Return Value…
Read more
Specifies the vertical footing for each page in a column-oriented report. Syntax PAGE RIGHT reportitem [:format:] Parameters reportitem Any valid expression. Complex expressions must be enclosed in parentheses. When you specify more than one expression, each must be separated from the next by at least one space. format A set of instructions defining the format…
Read more
English 
Portuguese