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:
00321824
Views:
18
>>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.


Thanx, I was trying to avoid AUSED(). The function I wrote takes between 1 and 2 seconds to return the alias of an open file or a fail code.
Fred Lauckner

You know, it works on my computer. I don't know what your problem is.

.Net aint so bad.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform