I suggest you to do:

Select 0
Use Table1 in 0
Use Table2 in 0
Use Table3 in 0

....
Select 0
Select field1, field2... from Table1... ;
Into Cursor Tmp1

Select 0
Select field2, field4, field6... from Table2...;
Into Cursor Tmp2

Why? why always Select 0 to get a new fresh work area!
if you don't select 0, use.. in 0, you lose the current work area!!!!!
Especially the Select-SQL cursor!

Select 0
Select field1, field2... from Table1... ;
Into Cursor Tmp1

Select field2, field4, field6... from Table2...;
Into Cursor Tmp2

Set View On && Only used Within VFP

What you would observe is that: Tmp1 Cursor is gone!!


>Hi,
>
>When we use the command:
>
>Use table in 0
>
>Does the 0 (Zero) ref a work area ?
>
>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
>
>select table2