vfp queries point to relative directory

Hi :
An irritating little feature of foxpro. I have two copies; one at work and one at home.
At Home when I create a query, then select a  query destination using the browse button, then view the SQL the table location is shown as relative; eg if I want to store  table stock.dbf  in C:\Stock then the SQL reads  "..\..\stock.dbf". Which, when I compile, does cause problems .
At work no problem - the SQL reads "C:\Stock\stock.dbf"
Anybody else experienced this?
Richard TeasdaleFinancial ControllerAsked:
Who is Participating?
 
pcelbaConnect With a Mentor Commented:
Tools - Options - File Locations - Default Directory

But I would recommend to add it into CONFIG.FPW and/or into a startup program.
0
 
pcelbaCommented:
This should depend on the current path set by SET DEFAULT. Your work path is porbably D:\MyWorkFolder\ wherease home default path is e.g. C:\Stock\Home\MyHomeFolder\.

0
 
Richard TeasdaleFinancial ControllerAuthor Commented:
Ahhh..Thank you, pcelba!
Please advise where SET DEFAULT is set...cannot see in config.fpw, and cannot find in tools/options
0
 
Richard TeasdaleFinancial ControllerAuthor Commented:
Excellent as usual...sorry if I am making you busy today!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.