Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6 How to detect a table in use by views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00948339
Message ID:
00948598
Vues:
19
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform