SELECT( ) Function
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
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
Reference
ALIAS( ) Function
SELECT Command
SET COMPATIBLE Command