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: Angler
  Where is Angler?
 Winnipeg
 Canada
 Angler
 Tags
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).

Cheers,
Jamie
jamie.osborn@foxite.com

ENTIRE THREAD

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