Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Trigger Question
Message
De
20/07/2001 17:32:21
Chris Laffoon
Florists' Interlink, Inc.
Paragould, Arkansas, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Update Trigger Question
Divers
Thread ID:
00533371
Message ID:
00533371
Vues:
34
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform