WHERE States a condition. Syntax WHERE expression Parameters expression A logic expression using conditional and Boolean operators. Comments WHERE states the conditions that restrict processing in the main command to only certain members of the set specification, contingent on a value within each of the (related) records being considered. Of all the available (related) records…
Read more
Defines the title of the row element Syntax set xml rowelement constant Parameters constant A character string or an expression that evaluates to a character string Comments SET XML ROWELEMENT defines the identification of the row element for each row data that is printed whenever the set output format xml or xmlsimple is set. By…
Read more
Controls lexical tracing. Syntax SET [LOCAL] LEXTRACE ON|OFF Parameters LOCAL Indicates that lexical tracing is to be switched ON or OFF only at the “local” level. Comments The LEXTRACE option is set OFF by default. When LEXTRACE is ON, each line of a procedure is displayed on the terminal, one character at a time, as…
Read more
Releases memory occupied by user-defined variables (including form fields and menu items) or result sets. Syntax DISPOSE option Parameters option Can be «item» The name of a variable, form field, menu item, form or menu whose current memory allocation is to be released. ALL Releases the current memory allocation of all user-defined variables, form fields,…
Read more
Calculates the cosine of a number. Syntax $cos(number) Parameters number a number, or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number. Comments The value returned by this function has the same number of decimal places as number. Ensure that you specify enough decimal places…
Read more
Calculates the arctangent (in radians) of the quotient of two numbers. Syntax $atan2(number1,number2) Parameters number1 a number, or an expression that evaluates to a number number2 a number, or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number1. Comments Number1 is divided by number2 before…
Read more
Decrypts the data in an EntitySet or relationship with fields. Syntax DECRYPT object Parameters object The name of a previously encrypted entity set or a relationship with fields. A role name can be used. Comments Reverses an ENCRYPT command. If the data in the specified EntitySet or relationship was not previously encrypted, the command raises…
Read more
Builds a single character string out of separate character strings. Syntax $concat(string[«,string»]) Parameters string A character string or an expression that evaluates to a character string. Each string must be separated from the next by a comma (,). Return Value Character string. Comments The function builds a single character string out of separate strings. Example…
Read more
Changes the name of certain objects. Syntax RENAME object oldname AS newname [IN directory] Parameters object One of CONSTANT, DIRECTORY, DISPLAY, DOCUMENT, ENTITYSET, FORM, RELATIONSHIP, ROLE, SET, VARIABLE, WINDOW oldname The current name of object. newname The new name for object. The new name must not be the name of an existing object. directory The…
Read more
Calculates one number modulo another. Syntax $modulus(expr1,expr2) Parameters expr1 a number, or an expression that evaluates to a number expr2 a number, or an expression that evaluates to a number Return Value Number, with no decimal places. Comments Expr1 modulo expr2 is the remainder of the division of expr1 by expr2. Before the operation is…
Read more
English 
Portuguese