Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Trigger Question
Message
From
20/07/2001 17:32:21
Chris Laffoon
Florists' Interlink, Inc.
Paragould, Arkansas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Update Trigger Question
Miscellaneous
Thread ID:
00533371
Message ID:
00533371
Views:
35
Is there a way, using an update trigger, to effect changes to a different table when a value in another table is changed?

For example:

Parent Table/Field: CLIENT.acctbal

Child Table/Field: TRANSACT.amount


Is there a way to edit an existing record in the TRANSACT table, and reflect the change in the CLIENT table? I don't see how to know what the original value was before the Update Trigger was called.

Thanks for any insight,
Chris
Next
Reply
Map
View

Click here to load this message in the networking platform