Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBF Table Security
Message
 
À
25/01/2007 12:26:48
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 7
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01189289
Message ID:
01189347
Vues:
8
Hi,

> Is it possible to maintain Free Table History that from which system Open any Table.

Yes, but it might slow down the application quite a bit. The only way to get notified when a field changes in a table is an index expression on every field that calls a user defined function. In this function you would have to determine if the record changed. In case it does, store the new values in a history table. The problem with this approach is that index expression are evaluated much more frequently than just when you change a field. Your code might be called very frequently.

The only other solution is to make tables private to your application either by encrypting them or by using a different user account for your application.
--
Christof
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform