Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jeff Barefoot
  Where is Jeff Barefoot?
 Roanoke
 Virginia - United States
 Jeff Barefoot
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Conditional Triggers
Thread ID: 331224 Message ID: 331281 # Views: 41 # Ratings: 0
Version: Visual FoxPro 8 Category: VFP and .NET
Date: Wednesday, December 28, 2011 2:00:11 PM         
   


It's a table in a VFP database. The procedure is stored in a .prg, not a SP. Sounds like that's the direction I need to move in. Thanks!

> > I've created audit trails for a VFP app using triggers. Each trigger calls a VFP procedure, which then logs as needed. This works great from within my app.
> >
> > PROBLEM - When the data is accessed from OUTSIDE of my app the triggers still attempt to fire and, of course, can't find my procedure. This can happen from a number of other apps that are related, or when browsing the data via VFP.
> >
> > What are the best practices in a situation like this? Need the trigger to fire when my app is running, but skip when the app isn't running.
> >
> > Thanks for your help!
> >
> > Jeff
>
> Is the table attached to a VFP database.
> Is the procedure stored in the same database.
> Who is peing and accessing the table outside your app. That's preventable.
> -Anders



Jeff

ENTIRE THREAD

Conditional Triggers Posted by Jeff Barefoot @ 12/28/2011 12:47:45 AM
RE: Conditional Triggers Posted by chaim dudi @ 12/28/2011 8:37:16 AM
RE: Conditional Triggers Posted by Jeff Barefoot @ 12/28/2011 1:58:25 PM
RE: Conditional Triggers Posted by Anders Altberg @ 12/28/2011 12:00:46 PM
RE: Conditional Triggers Posted by Jeff Barefoot @ 12/28/2011 2:00:11 PM
RE: Conditional Triggers Posted by Anders Altberg @ 12/29/2011 12:39:20 AM