INTERSECT

INTERSECT

Isolates the common members of two or more result sets.

Syntax

set1 INTERSECT set2

Parameters

set1A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure.
set2A result set produced from the execution of a set-producing command. All sets in the command must have the same component structure.

Comments

When used within a FIND command, the result set contains the members that are common to each of the specified result sets, with duplicates eliminated.

See Also

FIND

MINUS

UNION

MINUS

MINUS

Removes the members of one or more result sets from a another result set.

Syntax

set1 MINUS set2

Parameters

set1A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure.
set2A result set that resulted from the execution of a set-producing command. The sets must all have the same component structure.

Comments

When used within a FIND command, the result set contains all members of set1 that are not also in set2, and so on.

See Also

INTERSECT

Set Specification

UNION

$ProgramFileName

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

$ScreenWidth

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

$ScreenHeight

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

$TimeSecs

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

$True

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

en_CAEnglish