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?
 Jamie Osborn
 To: Angler
  Where is Angler?
Subject: RE: Triggers?? Need some Help
Thread ID: 15717 Message ID: 15748 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Sunday, September 29, 2002 12:03:31 AM         

> I have two tables in a DB. I would like to monitor 1 table for a change. The change is happening from a VBA Program running across a network using an ODBC Connection which updates a record in table 1. When this record changes I need to generate some record changes in table 2. Tried using triggers i.e. UPDATE Trigger, when table 1 is updated change record in table2. Always seem to get a Trigger error across the network.
> Anyone have any ideas

What errors did you get ?

You should test your trigger code in VFP to make sure it works (ie. step through with the debugger).



Triggers?? Need some Help Posted by Angler @ 9/27/2002 10:01:42 PM
RE: Triggers?? Need some Help Posted by Jamie Osborn @ 9/29/2002 12:03:31 AM