Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Trigger Question
Message
 
 
À
20/07/2001 17:32:21
Chris Laffoon
Florists' Interlink, Inc.
Paragould, Arkansas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00533371
Message ID:
00533636
Vues:
8
Your question is a little confusing to me. You can use the Update Trigger of a table to post updates to a different table. What you can not do is use an update trigger to post a data change to the table [i.e., the record] being updated.

>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
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform