I think the reason this happens is because dbf() returns the path and file i.e.
d:\temp\987654321.tmp. This is going to where your temp files are, which is probably different than where Fox is looking for tables, so you get the error. If you Select into cursor c:\datapath\cursorname where datapath is where your path or default is, then I think this will work.

>Hi Cetin,
>
>>>weirdness number 2: A Select out of DBF('curTest1') triggers a file blablabla.tmp not found error while an Append from DBF('curTest1') works fine?
>>
>
>>In second "weirdness" you would directly select from curTest1 not dbf("curtest1").
>
>I still don't know why the select * from DBF('curTest1') triggers a "blablabla.tmp not found" while the Append from DBF('CurTest1') works fine. I know I can do a select * from curTest1 but why does the DBF() function trigger the error here?