Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this table open under a different alias
Message
From
25/01/2000 09:18:38
 
 
To
24/01/2000 17:28:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00321816
Message ID:
00322138
Views:
33
>>>>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.
>>>
>>>AUSED() ...
>
>>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.
>
>Without using AUSED, you would have to attempt a USE on the table and see if it fails (obviously with error handling). Not cool.
>
>-- Randy

For some reason there are 189 work areas used. It takes a second to test each alias to see if its table I need, I was hoping for something faster.
Fred Lauckner

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

.Net aint so bad.
Previous
Reply
Map
View

Click here to load this message in the networking platform