Calculates the sine of a number. Syntax $sin(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…
Leia mais
Right-justifies a character string. Syntax $rightjustify(string) Parameters string a character string, or an expression that evaluates to a character string Return Value Character string, consisting of string right-justified in a space $length(string) characters long. Trailing blanks in string are ignored. Example $rightjustify(“abcde “) Evaluates to ” abcde”. $rightjustify(var1) Evaluates to ” 3″ if var1 is…
Leia mais
Sums a set of values, excluding those in which the expression is $Null. Syntax $total(expression) Parameters expression any expression Return Value Number. Comments Expression is often a WHERE expression that includes only selected values in the totalling operation. If the WHERE expression (expr1 WHERE expr2) is true, the expr1 value is included in the operation;…
Leia mais
Calculates the hyperbolic cosine of a number. Syntax $cosh(number) Parameters number a number, or an expression that evaluates to a number, representing an angle (in radians) Return Value Number, with the same number of decimal places as number. Ensure that you specify enough decimal places in your equation to ensure a sufficiently granular result. Unusual…
Leia mais
Enables or suppresses the display of information messages. Syntax SET INFORMATION ON|OFF Comments The INFORMATION option is set ON by default. When INFORMATION is ON, information messages are displayed. Setting INFORMATION to OFF suppresses the display of such messages. Information messages are of the form: nnn selected after a FIND command nnn added after an…
Leia mais
Records tracing information. Syntax SET TRACE OUTPUT docname [APPEND] Parameters docname The name of an application document. All subsequent trace output is sent to the specified document. APPEND Indicates that subsequent trace output is to be appended to the existing contents of docname. Comments Normally, information generated by the commands SET COMMANDTIMING, SET FLOW, SET…
Leia mais
Calculates the tangent of a number. Syntax $tan(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. Ensure that you specify enough decimal places in your equation to ensure a sufficiently granular result. Unusual results such as -0 are an…
Leia mais
Moves the current member pointer one or more records “up” in a result set. Syntax UP [num] [setname] Parameters num Can be: an integer constant (15, 200); a variable, form field, or parameter that evaluates to an integer; the word ALL. The default value of num is 1. If num is negative, the command effectively…
Leia mais
DDEExecute Send commands and macros to the target application. Syntax procedure DDEExecute (out tErrCode, inout tServ, in app_cmd) Parameters tErrCode longint, an error code tServ longint, connection handle app_cmd char, command or macro to be executed Comments DDEExecute sends target application specific commands and macros to be executed by the remote application. Consult the documentation of…
Leia mais
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…
Leia mais
Portuguese 
English