Hi,
My app has all free tables and every form's data environment is empty. My users are all on one campus, but on different networks. Some have Novell, some have NT, and some have Pathworks. I have no idea what their drive mappings are going to be. So, there is a form in my app where the user can enter the PATH to the data like: "M:\CONFIG\". Then the app carries the path as a variable. The path is stored in a field in a small table at the client.
When the app starts it opens the table and picks up the path:
use clientdat
mDatapath = clientdat.path
Later on, the LoadEvent of the Parent form opens the tables:
mDBFtable1 = mDatapath+'TABLE1.DBF'
mDBFtable2 = mDatapath+'TABLE2.DBF' , etc.
set excl off
sele 0
use &mDBFtable1 alias table1
sele 0
use &mDBFtable2 alias table2
sele table1
set rela to somefield into table2
Questions:
Is this a stupid way to do this?
Will this work when I create the .EXE and carry the app to other PCs?
Thanx,
John Morga
John Morga
Sr. Manager Information Systems
Applications Development Group
Systems Engineer
Telephonics Corporation
http://www.telephonics.com