Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Angler
  Where is Angler?
Subject: Triggers?? Need some Help
Thread ID: 15717 Message ID: 15717 # Views: 0 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, September 27, 2002 10:01:42 PM         

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


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