switch VFP 6.0 data retrival from a separate computer to my own 1

[ammmum]

I am using vfp 6.0 on xp for my one-person business. Originally the program was written, when I had multiple people in my office. The main program was on a separate computer, call it comp data on NT, and all the satellite computers would contact comp data for info, editing etc. Even after becoming the only user, I still retrieved and edited all info from comp data. Unfortunately, my programmer from 1995 died and I don't know how to switch the foxpro program from searching the date on comp data to a data file on my own computer. Is there anyone that would point me in the right direction?

Many thanks, ammmum

 

[steve3739]

To ammmum,
You might check these two things:

1) If you have a desktop shortcut to start the program, you may need to change the TARGET and START IN fields to the current location of the data files.

2) There may also be a CONFIG.FPW file which points to the data files. For example, I use something like the following:

resource = d:\myuserdir\foxuser
path = d:\datadir

Hope this helps.
Steve

 

[alvechurchdata]

2) There may also be a CONFIG.FPW file which points to the data files.

I use an old-fashioned Ini file for the same purpose and I have seen a config table used. Look for a very small text file or a very small dbf. Either will probably be in the same folder as the exe because that's the easiest place to find it.

If the path has been hard-coded into the body of the code then you'll have to get someone to edit the program and rebuild you a new executable. If you don't have the source code then things get more complicated (and expensive).

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ammmum]

[Q]steve3739 (Programmer)
25 Apr 06 18:02
To ammmum,
You might check these two things:

1) If you have a desktop shortcut to start the program, you may need to change the TARGET and START IN fields to the current location of the data files.

2) There may also be a CONFIG.FPW file which points to the data files. For example, I use something like the following:

resource = d:\myuserdir\foxuser
path = d:\datadir[/Q]

I found the CONFIG.FPW file that is 1mb. When I double-click vfp opens up, but the big screen and command box are empty. I typed quit to exit. Do I need to type somthing to pull the resource or path commands?

Again, thank you so much,

ammmum

 

[steve3739]

To ammmum:
The CONFIG.FPW file is a plain text file. You should be able to open and edit it with window's notepad.exe program. There is no telling what you will find there, but hopefully there are only directory entries which you can change to point to your current data location. Good luck.

Steve

 

[ammmum]

Steve,

Thank you so, so, so much. I didn't have a clue about using notepad.exe. I checked out the CONFIG.FPW file, but it had this:

MVCOUNT=4500
MEMLIMIT=70,1024,4096
FILES=99
BELL=OFF
TALK=OFF
STATUS=OFF
SAFETY=OFF
SYSMENU=OFF

So I manually went through every file and I found three files with an E drive path. I didn't understand the coding, but remembered that I had a backup using VFP 2.6, that used the C drive path at home. I copied the three C drive path files and pasted them over the ones in the office. And it worked!!! I have to admit that I was ridiculously proud of myself, since I have never done any programming.

The coding in one looked like: _

A 3 LOC C
2
c:\mycompany\data\ 

Again, many thanks,

you are a life saver,

ammmum