Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
About Trigger Update!
Message
De
23/05/1999 23:16:50
 
 
À
23/05/1999 22:26:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00221964
Message ID:
00221978
Vues:
13
>I have a Staff Table with a DateTime field "UpdateTime",
>
>Can I write a table Update Trigger to make a copy of non-update record with out "UpdateTime" in Same Table!?
>

No... a trigger may not update the table that fired the trigger... however, I think you can do this with a Table Rule. But, won't that cascade?

If you want to use a trigger why not write your record to another table. If you use views you can union that tables togther to see them as 'one' table.

BOb
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform