Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Errors 1705, 108, 109
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01225187
Message ID:
01226133
Vues:
18
This message has been marked as the solution to the initial question of the thread.
Hi,

>At this moment i'm trying to do that, but now the problem is that in have about 800 tables and thousands sentences use in my system. now i´m trying to "capture" when i use a table and when i use in a table and write it on a log

I think you should be able to use the DBC events to get notified when a user opens and closes a table. In the AfterOpenTable event you could add a record to a table that contains the table name and the user name. Keep this record locked. In the AfterCloseTable you can unlock this record and delete/blank it.

In your monitoring tool, you can display this log table. To verify if the user is really still working on the table, you can attempt to lock the record. If it became available, the application terminated unexpectedly, otherwise it's still running.
--
Christof
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform