Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use tables in Private Datasession ?
Message
From
07/06/2012 17:18:14
Luis Navas
Independent Consultant
Auckland, New Zealand
 
 
To
07/06/2012 04:00:57
Yim Ming Sun Derek
Spacious Design Consultant
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01545423
Message ID:
01545624
Views:
50
>Hi,
>When I put the tables into the DE, VFP9 will prompt out a dialog box
>to locate the tables in which database. So the tables which in DE is belong
>to the database, it is already specified.
>
>I need access which database and which tables at runtime.
>
>Derek

Yes I understand that, but that is why you will write code in the BeforeOpenTables event and change the Database there like this:
This.Cursor1.Database = Goapp.cPath + "MyData.dbc" &&Goapp.cPath stores the path to the DB
This.Cursor2.Database = Goapp.cPath + "MyOtherData.dbc"
This.Cursor3.Database = "c:\Test.dbc"
This.Cursor4.Database = "d:\op_serv.dbc"
I never forget a face, but in your case I will make an exception :-)
Previous
Reply
Map
View

Click here to load this message in the networking platform