SELECT( ) Function

  • Article

Returns the number of the currently selected work area or the highest-numbered unused work area.

SELECT([ 0 | 1 | cTableAlias ])

Return Values

Numeric

Parameters

  • 0
    Specifies that SELECT( ) return the number of the current work area.
  • 1
    Specifies that SELECT( ) return the highest-numbered unused work area.
  • cTableAlias
    Specifies the alias of the table for which SELECT( ) returns the work area.

Remarks

SELECT( ) returns the number of the current work area if SET COMPATIBLE is set to OFF. If SET COMPATIBLE is set to ON, SELECT( ) returns the number of the unused work area with the highest number.

A work area can be selected (activated) with SELECT.

Example

CLOSE DATABASES
SET COMPATIBLE ON
OPEN DATABASE (HOME(2) + 'data\testdata')

SELECT 0  && Unused work area
USE customer  && Opens Customer table

SELECT 0  && Unused work area
USE orders  && Opens Orders table

CLEAR
? SELECT( )  && Returns 3, lowest available work area

See Also

ALIAS( ) | SELECT | SET COMPATIBLE