Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is the Table Open?
Message
From
13/04/2000 10:28:18
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00359251
Message ID:
00359265
Views:
13
>You can try a combination of the following commands:-
>
>? used("tablename")
>
>Returns .T. or .F. if the table is in use.
>
>? cursorgetprop("database", "tablename")
>
>Extracts the database name if part of a container.

I failed to mention that both tables were views...

If I check used(), it will return .t. no matter which database its part of, right? And if both databases are open, then how do I know which database has that view open? It might well be that I'll need the view open in both databases at the same time, which will result in an alias. Maybe I should just make up an alias when I open the table that indicates the database as well?
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform