Solved

vfp queries point to relative directory

Posted on 2011-09-26
4
255 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
aprinters() not working in EXE 8 657
SQLite with C# using SQLiteWrapper 3 620
Overlay data type 17 84
vfp 9 and macintosh 7 137
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…
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now