$iswinopen

Determines if a particular window is currently open for use.

Syntax

$iswinopen(string)

Parameters

stringa 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

$minutes

Extracts minutes information from a standard time value.

Syntax

$minutes(time)

Parameters

timean 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

$seconds

Extracts seconds information from a standard time value.

Syntax

$seconds(time)

Parameters

timean 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

$log10

Determines which exponent of base 10 yields a given value.

Syntax

$log10(number)

Parameters

numbera 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

SET RUNTIME

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

$log

Determines which exponent of the natural base (e) yields a given value.

Syntax

$log(number)

Parameters

numbera 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

$hours

Extracts “hours” information from a standard time value.

Syntax

$hours(time)

Parameters

timean 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

SET STRATEGY

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

$LastErrMessage

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

$sinh

Calculates the hyperbolic sine of a number.

Syntax

$sinh(number)

Parameters

numbera 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

pt_BRPortuguese