Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Are Triggers Traditionally Recursive in Back Ends?
The use of triggers in VFP is sometimes limited by the nature of how they cannot be coded to change the base record or else the trigger fires itself. This means that features like timestamps and revision number incrementing need to be handled in other ways.
My question is whether this is the traditional approach of most back ends that support triggers? Do any of the major players like SQL Server, Oracle or DB2 offer any options? [For example, something like a NORECURSE clause in a specific trigger.]
TIA,
-- Randy
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement