About Markish Expertise I can answer general questions related to Foxpro from Version 2.0 to 9.0. I'll try to answer them as quickly as possible.
Experience I've been into Dbase programming from age of 11. I've worked in versions from FoxPro 2.0 and Foxbase. Education/Credentials I've done my B.Tech (IT) with distinction from Anna University, Chennai - India.
I have stored all the tables and the database in data1 folder
I am opening the tables of database in the form design database environment
Table property cursor database it takes data from data1 folder
But if I want to access data of other company in data2 folder what should I do.
I want to keep the forms reports and query same and access different database
Please advice
Answer Hi Allauddin,
IMHO, if you are using the tables dynamically, I don't prefer Data environment. Instead I open all the tables in a new custom method from Form's load event. Using the variable for source directory. SOmething like
sele 0
mdir=CURDIR()
mfnam=mdir+"\test.dbf"
if !used('test')
USE (mfnam)
endif
So whenever you want to change, just set the variable 'mdir' and call this form's method.
