Closes the open menu in the current window. Syntax MENU CLOSE [object] Parameters object Can benameThe name of the menu to be closed.(expr )A character string, or an expression that evaluates to a character string, used at run time as the name of the menu. Using expr enables one MENU CLOSE command to specify different…
Read more
Specifies the characters to be displayed for $Null values. Syntax SET NULLVALUE constant Parameters constant A character string, or an expression that evaluates to a character string. Comments The NULLVALUE option is set to a space character by default. When a value to be output is $Null, the specified constant is displayed. Example To specify…
Read more
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
Sets the focus on a particular form field. Syntax FORM SET FOCUS «object» Parameters object Can be formfield The name of a field within an open form. To specify a particular instance of a form field, append the instance number in brackets. ([exp1 ],[exp2 ],[exp3 ]) Positive integers or expressions that evaluate to positive integers,…
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
English 
Portuguese