General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only