>Hi,
>
>When we use the command:
>
>Use table in 0
>
>Does the 0 (Zero) ref a work area ?
>
Yes - the first available unused work area - it's resolved dynamically. It's left to VFP to pick somewhere that isn't being used already.
>And if so can you use the command in the following manner?
>
>Use table1 in 0
>Use table2 in 1
>Use table 3 in 2
>
No, because any value other than 0 specifies a precise workarea, even if it is currently used by something else. To open the tables in 3 unused work areas, letting VFPhandle selecting the workarea:
USE Table1 IN 0
USE Table2 IN 0
USE Table3 IN 0
The issue of using numbered work areas when referencing active tables really isn't a concernsince we can work with hundreds of tables at once and refer to them by name rather than having to track which numeric work area got used.
>select table2
SELECT Table2 works withoutever knowing which workarea was assigned.