SELECT field1 from test a1 into cursor c_test. There is no "a1" alias left open.
>select * from (dbf("test_in")) into cursor test >>
>close data all >use test alias test_in >select * from test_in into cursor test1 >*!* the data session contains "TEST_IN" and "TEST1" as open workarea aliases >*!* but not "TEST" > >close data all >use test alias test_in >select * from test into cursor test1 >*!* the data session contains "TEST_IN" and "TEST1" as open workarea aliases >*!* but not "TEST" > >close data all >select * from test into cursor test1 >*!* the data session contains "TEST" and "TEST1" as open workarea aliases >>With Glenn's error and the above examples, that seems to suggest to me that VFP opens another instance of test.dbf for each of the select statements, but automatically closes "TEST" workarea if the underlying table was already in use in another workarea. Can that be?
>>>create table test ( ctest c(10)) >>>append blank >>>append blank >>>append blank >>>use >>> >>>use test alias test_in >>>select * from test_in into cursor test >>>>>>