Keep key/data in different directory from tables

Jose Lerebours fpgroups at gmail.com
Sat Apr 27 00:24:17 UTC 2024


Objective:

I need to keep key/data and indexes in one directory and all processing 
tables, screens, forms/reports in a 2nd directory


I tried these but they access the same key/data (or look for it in same 
path) in /appl/filepro/[fp-file-name]

set PFDSK=C
set PFDATA=C:\
set PFPROG=C:\appl
set PFDIR=\appl


set PFDATA=C:\appl\fpdata
set PFPROG=C:\appl
set PFDIR=\appl


I run two different .bat shortcuts, each set as above respectively, but 
no matter what PFDATA is set to, the same key is accessed and updated.

Shouldn't filePro look for key/data based on PFDATA?

Is it not possible to have key/data in one directory and the rest on a 
2nd directory?


If you wonder why:

Need to sync two server but do not want to affect key/data nor indexes 
going UP and the DOWN sync is the other way around, sync everything but 
key/data and indexes.

Think of it this way, site (A) is live and data is entered daily, site 
(B) is UAT where we write code, test  but it is also where we backup 
site (A) data to.  So, we like to keep data from (A) backed up into (B) 
and once BETA is ready for production, sync from (B) to (A) without 
worrying about overwriting production data nor having development 
(test/UAT) mess with data backed up from (A)


Any suggestions?  I've tried a number of combination but cannot get it 
to work.  I even removed key/data from one of the PATHs 
(/appl/filepro/[filename]/key) and opened the option intended to access 
data in /appl/fpdata/appl/filepro but it gives me an error because 
key/data were missing in /appl/filepro/[filename] ...


Regards,


--
Jose Lerebours






More information about the Filepro-list mailing list