Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening muliple databases
Message
From
31/05/1997 19:54:12
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00034380
Message ID:
00034394
Views:
35
>You can open multiple databases at one time? i.e:
>OPEN DATBASE ONE
>OPEN DATBASE TWO
>OPEN DATBASE THREE
>and you can do:
>USE ONE!TABLE1 IN 0
>USE TWO!TABLE2 IN 0
>USE THREE!TABLE3 IN 0
>
>How can you tell that table1 is open in database ONE, and table2 is open in database TWO, etc.? The USED() function does not provide for specification of which database you are wanting to see if the table is opened in. i.e.:
>IF USED("TWO!TABLE2") does not work (returns a false every time).

Try :
If used("table1")
? cursorgetprop("Database","table1") && You can check dbc() to test if db is open in current work are
endif
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform