Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBF Table Security
Message
 
To
25/01/2007 12:26:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01189289
Message ID:
01189347
Views:
7
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
Previous
Reply
Map
View

Click here to load this message in the networking platform