Metin,

you add too many apostrophes, and you forgot one parenthesis

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

May I ask what you really try to do, I get the feeling that you can do this much easier.


>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