JavaScript Editor js editor     Web development 



Main Page

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

SELECT([ 0 | 1 | cTableAlias ])

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.

Return Value

Numeric

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

В Copy Code
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



JavaScript Editor js editor     Web development