UNRELATED

In a set specification, selects non-matching members of an EntitySet, a relationship with fields, an application document, or a result set.

Syntax

object (UNRELATED)

Parameters

Comments

In a set specification, UNRELATED selects all records in object that do not satisfy the relationship condition expressed in the set specification.

UNRELATED can be used only once in a set specification.

This function is related to the theoretical partial outer join operation.

Example

> find all Employees (unrelated) WorkIn Departments

> list all
LastName  FirstName  DeptNum  DeptName DeptNum
Johnston  Leslie   D07
Nelson    John
Kelly    Pat

The preceding command finds all employee records that contain no DeptNum, or contain a DeptNum for which there is no corresponding department record. Missing values are undefined ($Null).

find all Employees WorkIn Departments (unrelated) keep Departments

The preceding command creates a list of all departments that have no employee records associated with them.

find all Managers (unrelated) Manage Employees

Finds all employees that do not manage anyone. (For a contrasting example, see COMPLETE.)

See Also

– (Dynamic Rename)

COMPLETE

USING

Syntax

$ProgramFileName

Return Value

Character string (varalpha). Cannot be reset by an application program.

Comments

Contains the file system name of the disk file that contains the currently executing program. AREAS.ZIM or DIRS.ZIM entries that apply to the file are expanded, as are the special prefix characters (i.e. #,),^,~,”).

See Also

$filepath

Sets the minimum acceptable date.

Syntax

SET VALIDDATE min_date

Parameters

Comments

Example

By default, the minimum acceptable date in Zim is 0. The following assignments are accepted without warnings

>let nDate = 0.

>let pDate = 19991231.

>let qDate = 20010101.

However, when the minimum acceptable date is set to 20000101, the first two assignments generate warnings:

>let nDate = 0.

*** Warning *** DATE value is invalid but the operation was performed.

>let pDate = 19991231.

*** Warning *** DATE value is invalid but the operation was performed.

The following assignment executes without warnings:

>let qDate = 20010101.

Captures a bitmap image of the screen and writes it to a file.

Syntax

$screensave(filename)

Parameters

Return Value

Returns “1” ($True) if no errors were detected when the image was written to filename. Otherwise, returns “0” ($False).

Comments

Filename must be the name of a disk file, including the path location. A document name cannot be used.

The size of the terminal screen in character columns.

Syntax

$screenwidth

Value

A number. Cannot be reset by an application program.

Description

$ScreenWidth gives the width of the terminal screen in character columns.

In graphic environments, the number of columns depends on the font and point size used in the application window (BACKSCREEN).

See Also

$ScreenHeight

System Variables

ThisWindow

Controls the availability of the “break” key to the application user.

Syntax

SET BREAKABLE ON|OFF

Comments

The BREAKABLE option is set ON by default.

When BREAKABLE is ON, the application user may press the “break” key to terminate any command being executed. SET BREAKABLE OFF instructs the software to ignore the signal generated by the terminal “break” key.

The SET BREAKABLE command is not affected by the SET RESET and SET RESTORE commands.

See Also

$BreakFlag

The size of the terminal screen in character rows.

Syntax

$screenheight

Return Value

A number. Cannot be reset by an application program.

Description

$ScreenHeight gives the height of the terminal screen in character rows.

In graphic environments, the number of rows depends on the font and point size used in the application window (BACKSCREEN).

See Also

$ScreenWidth

System Variables

ThisWindow

Specifies how the FieldMask is treated in a LIST command.

Syntax

SET OUTPUT MASKFIELD ON|OFF

Comments

The OUTPUT MASKFIELD option is set ON by default.

Normally, the FieldMask is used to format data output from the database using the LIST command. To suppress the FieldMask, set OUTPUT MASKFIELD to OFF.

The OUTPUT MASKFIELD setting is unaffected by the SET SAVE and SET RESTORE commands.

See Also

LIST

Output Masks

The elapsed number of seconds since 12:00 am, 1 January 1970.

Syntax

$timesecs

Return Value

A number. Cannot be reset by an application program.

Description

The number of seconds that have elapsed since 12:00 am on 1 January 1970.

This variable is useful for measuring the number of seconds between two events.

See Also

$Date

$Time

A binary true value for comparison.

Syntax

$true

Return Value

Binary true (“1”). Cannot be reset by an application program.

Description

A “true” value for comparisons in logic expressions.

Example

if Event.ScrollingKey = $True
 ... commands ...
endif

See Also

$False
$Null