Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which database am I?
Message
From
10/09/2002 02:47:19
Walter Meester
HoogkarspelNetherlands
 
 
To
09/09/2002 14:19:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00698416
Message ID:
00698641
Views:
19
Ramil,

Not trying to be picky, but the DBC() function only returns the current selected database. It does not give you the database for the current selected alias.

Tip. You can use the SET DATABASE command with a full path notation to differentiate between the two.

Walter,

>Thanks. Both your reply and Sergey's work. He just beat you by seconds and you could have the 3 stars instead.
>
>>Hi Ramil,
>>
>>Try
>>
>>cDatabase = CURSORGETPROP("Database",cMyAlias)
>>cDatabase should now contain the fullpath of the database container.
>>
>>Walter,
>>
>>>Hi all,
>>>
>>>Is there a way to identify which database is which in this case?
>>>
>>>* known: two databases of the same name (MyDatabase) in different folders
>>>use dataset1\table1 in 0 && (MyDatabase.dbc in \dataset1)
>>>use dataset2\table2 in 0 && (MyDatabase.dbc in \dataset2)
>>>
>>>Both databases will be opened in VFP. How can I tell one database from the other?
Previous
Reply
Map
View

Click here to load this message in the networking platform