Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 How to detect a table in use by views
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00948339
Message ID:
00948598
Views:
18
This message has been marked as the solution to the initial question of the thread.
>Hi Nadya
>
>Thanks for responding.
>
>>Do not use "USE" command directly. It should be wrapped into a procedure with ERROR trapping code. I posted here my version OpenTble several times, but it could be improved now using VFP8 syntax.
>
>I guess it is time to post it again <g>. Sorry, but I seem to have missed those posts, or better still why not make a download of it.
>

See message #829501

>All in all the original response was nice, in which to close all the open forms and then, if successful, to proceed with the utility. But still what will happen when the app is working over a network?

That's why you need an error trapping procedure. That's basically the only way to find, if the table could be opened excusively or not.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform