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