>Hi Paul,
>
>Yes, I realized this in my testing on vfp6. Do you happen to know the limits in the various versions of foxpro? And do you happen to know when select(1) was introduced to the language? Do you know when aused() was introduced?
>
>Thanks.
>
>>
>>SELECT(1) returns the highest numbered unused workarea, which in VFP is a staggering 32767.
>>USE ... IN SELECT(1) will open a table in the highest unused workarea.
>>A following SELECT(1) returns 32766 because 32767 is in use.
If you have to support those versions, I am guessing you have thoses versions handy. Check the Help file. There should be a topic on VFP Limits/Limitations. The work area information should be there.
As for your other questions, I think AUsed() was introduced in 6 when many of the other A... functions were. I don't remember when SELECT(1) was introduced. Perhaps the Help file can be of assistance in this case as well.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao