Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Multiples databases from a single form
Message
From
13/01/1999 11:10:30
 
 
To
13/01/1999 11:07:01
Noman Aftab
Embry-Riddle Aeronautical University
Daytona Beach, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00175474
Message ID:
00175476
Views:
23
>Hi evereyone!
>I have a form where I have three buttons so that I can access info from separate databases each time. The problem is how can I open each database for each click and close the ones not in use. Do i need to add all the tables from all databses to the data environment. Actually these databses have same tables, stucture-wise and name-wise, but databse names are different.
>PLEASE HELP!

I think it would be enough to change database (CLOSE/OPEN DATABASE) and then fire:
cDbcpathname=dbc()
Thisform.DataEnvironment.CloseTables
Thisform.Setall("Database",cDbcpathname,"Cursor")
Thisform.DataEnvironment.OpenTables
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform