Information générale
Forum:
Microsoft SQL Server
Titre:
Determining trigger level
Versions des environnements
SQL Server:
SQL Server 7.0
HI All,
Is there an equivalent in SQL to the VFP _Triggerlevel system variable?
The scenario I am trying to cope with is as follows:
When an order line is deleted by the user I want to write a record to another database via the order line delete trigger.
When an order header record is deleted I want the order header delete trigger to delete the child order lines but I do NOT want the order line delete trigger to write records to the other database. I only want to capture the order lines that have been deleted by direct user action.
In VFP I could achieve this by checking the _triggerlevel variable.
TIA,
Andy
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