>>The value *is* documented if "mytable" is USED().
>
>Nope. It's not documented. At least not in VFP 6/7 help.
VFP6 docs:
************
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.
**************
What is missing?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up