Returns the number of the currently selected work area or the highest-numbered unused work area.
Syntax
SELECT([ 0 | 1 | cTableAlias ])
Returns
Numeric
Arguments
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.