Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this table open under a different alias
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00321816
Message ID:
00321821
Views:
16
>Is there an easy way of telling if a table (in a multiuser environment) is already opened in the current data session under an unknow alias (don't ask)? I could always scan though all open work areas and test the table name of the alias, but that seems like the long way of getting the answer.

Fred,

AUSED() returns the workareas and aliases of the files opened in the current data session or specified one. Simply use that in conjunction with DBF() to determine if a file is in use under a different alias (i.e.: IF lcfile = DBF(a_used[lni, 1])). AUSED() also will let you indicate the datasession number.
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform