Tests if a character string is a valid date. Syntax $isdate(string) Parameters string a character string or an expression that evaluates to a character string Return Value 1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False). Comments This function tests if a particular character string is…
Read more
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…
Read more
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…
Read more
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;…
Read more
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…
Read more
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…
Read more
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…
Read more
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…
Read more
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…
Read more
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…
Read more
English 
Portuguese