it gives "file is in use" error. only difference I could see with yours I used paranthesis with use dbf(... command. I tried either, no success.. :(

CREATE TABLE test (testfld c(10))
SELECT * FROM test INTO CURSOR xx
USE IN "test"
USE DBF("xx") IN 0 ALIAS "test"
USE IN "xx"

>No. Try the one I wrote. You forgot "again". What error it gives otherwise?
>Cetin
>
>>I tried that one. It gives error. Isn't that what you mean?
>>
>>
>>

>>CREATE TABLE test (testfld c(10))
>>SELECT * FROM test INTO CURSOR xx
>>SELECT test
>>USE
>>USE (DBF("xx")) IN 0 ALIAS test
>>SELECT xx
>>use
>>

>>
>>>>>select * from customer into cursor xx nofilter
>>>>>use in 'customer'
>>>>>use dbf('xx') in 0 again alias 'customer'
>>>>>use in 'xx'
>>>>>
>>>>>Cetin