Determines if a particular window is currently open for use.
Syntax
$iswinopen(string)
Parameters
string | a character string or an expression that evaluates to a character string |
Return Value
Evaluates to “1” ($True) if string is the name of a window that is currently open; otherwise, evaluates to “0” ($False).
Comments
Use the value of the function to determine if a particular window is currently open.
See Also
About Functional Expressions
ThisWindow
WINDOW OPEN
Extracts minutes information from a standard time value.
Syntax
$minutes(time)
Parameters
time | an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT |
Return Value
Number.
Comments
The system variable $Time is often used for time.
Example
$minutes($Time)
Evaluates to 59 when $Time has the value 23595999.
See Also
$hours
$seconds
$ticks
About Functional Expressions
Extracts seconds information from a standard time value.
Syntax
$seconds(time)
Parameters
time | an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT |
Return Value
Number.
Comments
The system variable $Time is often used for time.
Example
$seconds($Time)
Evaluates to 59 when $Time has the value 23595999.
See Also
$hours
$minutes
$ticks
About Functional Expressions
Determines which exponent of base 10 yields a given value.
Syntax
$log10(number)
Parameters
number | a positive number or an expression that evaluates to a positive number |
Return Value
Number, with the same number of decimal places as number.
Example
let var1=$log10(100)
The above expression means “the exponent of base 10 that yields the value 100” and evaluates to 2.
See Also
$exp
$log
$sqrt
About Functional Expressions
Determines if compiled versions of application programs are to be executed.
Syntax
SET [LOCAL] RUNTIME ON|OFF
Comments
Specifies if the Runtime system is to be available for program execution. When RUNTIME is set OFF, compiled programs are treated as if they are not compiled.
A SET LOCAL RUNTIME command can be used inside a program to make the Runtime system locally available to that program when RUNTIME is globally switched off. If that program subsequently calls another program, however, the Runtime system is unavailable within the second program.
The SET RUNTIME command is not affected by the SET RESET and SET RESTORE commands.
See Also
COMPILE
TRANSFORM
UNCOMPILE
Determines which exponent of the natural base (e) yields a given value.
Syntax
$log(number)
Parameters
number | a positive number or an expression that evaluates to a positive number |
Return Value
Number, with the same number of decimal places as number.
Example
$log(7.389)
The above expression means “the exponent of the natural base that yields the value 7.389” and evaluates to 2.000.
See Also
$exp
$log10
$sqrt
About Functional Expressions
Extracts “hours” information from a standard time value.
Syntax
$hours(time)
Parameters
time | an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT |
Return Value
Number.
Comments
The system variable $Time is often used for time.
Example
$hours($Time)
Evaluates to 23 when $Time has the value 23595999.
See Also
$minutes
$seconds
$ticks
Controls tracing of retrieval strategy information.
Syntax
SET STRATEGY ON|OFF
Comments
The SET STRATEGY command is OFF by default.
When SET STRATEGY is set ON, the software displays the chosen retrieval strategy for each command that accesses the database (i.e., FIND, COMPUTE, LIST, REPORT FROM, CHANGE, ADD, DELETE, SELECT, UPDATE). The retrieval strategy information is written to the destination specified in the last SET TRACE OUTPUT command.
See Also
ADD
CHANGE
DELETE
FIND
LIST
REPORT FROM
SELECT
SET SELECTIVITY
SET SIZE
SET TRACEOUTPUT
UPDATE
The error message generated by the last command that returned an error code.
Syntax
$lasterrmessage
Value
A character string. Can be reset by an application program.
Description
$Null at the beginning of each application session. The value changes only if an error occurs, or if the application program explicitly assigns a value.
When non-$Null, the variable represents, for the current session, the software message generated for the most recently executed command that returned an error code.
See Also
$ErrCode
$ErrLevel
$LastErrLevel
$MaxErrLevel
System Variables
Calculates the hyperbolic sine of a number.
Syntax
$sinh(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.
Comments
This function calculates the hyperbolic sine of a number.
Example
let vAngle = $sinh(3.000)
Evaluates to 10.018.
See Also
$asin
$cosh
$sin
$tanh