Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open database with alias name
Message
 
To
18/06/2001 13:20:34
Valter Herman
Tuesday Morning, Inc.
Dallas, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00520670
Message ID:
00520705
Views:
17
>Is there anyway to open up two databases with the same name, one on the local machine, one on a remote machine? There is no 'ALIAS' clause in the 'OPEN DATABASE' statement so that makes it almost impossible to refer to the two databases distinctively.
>
>Thanks for your help,
>
>Valter

Sure it will be confusing to VFP. You can open two database with the same name simultaneously, however you have to use SET DATABASE TO fulldatabasepath to select the particular one. Even if you do this, the table from the database which was opened first will be USEd if you address it

USE myDatabase!myTable
instead of
USE "s:\mynetworkdirectory\data1\myDatabase!myTable"

May be you can try to open the databases with the same name in different Private datasessions (if appropriate)?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform