Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I re-structure this user tracking feature?
Message
From
21/05/2002 11:03:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How can I re-structure this user tracking feature?
Miscellaneous
Thread ID:
00659398
Message ID:
00659398
Views:
52
In my master base form, in the load() event, I open a table called "Tracker", then I make a new record of the user name, date time, form name, and action(s) (add, edit, preview, print, etc) they make while using the form. I can then see who did what and when. Kind of a Big Brother thing. I usually purge off records older than two weeks.

Anyway, all my forms are modeless, and have their own private datasession, so a user can have about three or four forms open at once, and each one opens it own copy of "Tracker". Since all I do is append new records, I am wanting to only open one copy of Tracker in some central area.

Basically, I do not know how to write to a table outside of the current private datasession, and are there any drawbacks to this. ALl other tables must stay in the private datasession.
Next
Reply
Map
View

Click here to load this message in the networking platform