I am having a "blind" moment:

On my local development pc I have a folder C:\MYDATA\DBFS

I am running a query which utilises tables from this folder e.g. invent.dbf

I am setting the search path as follows:
SET PATH TO C:\MYDATA\DBFS\

When I run the query and inspect the debugger, I can see the path is set correctly to C:\MYDATA\DBFS and the dbf() returns C:\mydata\dbfs\invent.dbf

I now set

SET PATH TO S:\MYDATA\DBFS\

to run the query against a server data set.

Now when I inspect the debugger I can again see the path is correctly changed to S:\MYDATA\DBFS\, but the dbf() still returns C:\mydata\dbfs\invent.dbf instead of what I was intending i.e. S:\mydata\dbfs\invent.dbf.

Why is the dbf on the S path not being picked up?

Barry Sutton