Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 To: Kev InAz
  Where is Kev InAz?
 
 Arizona - United States
 Kev InAz
 Tags
Subject: RE: Tracking Record Changes In a Table.
Thread ID: 33795 Message ID: 33816 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Wednesday, December 03, 2003 11:41:25 PM         
   


>
> I have a client who has an inventory system I created that does record the user name and time of any transaction.
>
> The problem is a bunch of records were changed in their inventory and all the user and time fields are blank. Another problem is that some of the owners use VFP.exe to view a table directly and sometimes make changes.
>
> Now the main owner wants to know why all those records got changed.
>
> I know in a database container you can have a program run every time the table is accessed. But all the tables in this application are not in database containers. So my question is, is there a way to have a program run every time someone accesses a table that is not in a database container. Even if it's opened in VFP.exe?

With free tables no.

Cheers,
Jamie
jamie.osborn@foxite.com

ENTIRE THREAD

Tracking Record Changes In a Table. Posted by Kev InAz @ 12/3/2003 6:53:52 PM
RE: Tracking Record Changes In a Table. Posted by Jamie Osborn @ 12/3/2003 11:41:25 PM