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 |