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.
QUESTION: Hi Markish ,
Thanks for the replay
how can i use tables dynamically in visual foxpro report writer
Please Help me out, I would be very thankful to you
Best regards,
allauddin
Answer Hi Alaudddin,
Sorry for the delay in my response. The same logic applies here. Dump your data to a temperorary table and design the report using that table.
Now in your program, before calling the report, just dump the data to the temporary tables.
