Solved

vfp queries point to relative directory

Posted on 2011-09-26
4
272 Views
Last Modified: 2012-08-13
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?
0
Comment
Question by:ClaytonGlass
  • 2
  • 2
4 Comments
 
LVL 41

Expert Comment

by:pcelba
ID: 36598842
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
 

Author Comment

by:ClaytonGlass
ID: 36598986
Ahhh..Thank you, pcelba!
Please advise where SET DEFAULT is set...cannot see in config.fpw, and cannot find in tools/options
0
 
LVL 41

Accepted Solution

by:
pcelba earned 50 total points
ID: 36599037
Tools - Options - File Locations - Default Directory

But I would recommend to add it into CONFIG.FPW and/or into a startup program.
0
 

Author Closing Comment

by:ClaytonGlass
ID: 36599071
Excellent as usual...sorry if I am making you busy today!
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question