Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining maximum number of workareas
Message
From
17/10/2002 14:33:37
 
 
To
16/10/2002 19:25:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00711750
Message ID:
00712502
Views:
8
You run into problems where someone else's code has opened and closed tables and leaves gaps in the workarea numbers used.
Provided the USE ... IN 0 form is always used, then there's no problem because the first unused workarea is reused. Either SELECT 0 then USE or USE...IN 0 opens in the lowest numbered unused workarea.

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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform