>Well, to me, all this seems more complicated than setting a variable to disable a certain trigger! As you would do with TaxRI.
>
>Hilmar.

On further checking, when you do a DELETE TRIGGER it is permanently gone from the database container. Why it still executed later is a mystery...

But I went ahead and added code to check to see if the database had any DELETE triggers after opening the database...

lcCont = DBGETPROP('cont','Table','DeleteTrigger')

and if this was not empty, then I deleted the Trigger

DELETE TRIGGER ON cont FOR DELETE..

Later in the code, before I finish, I add the trigger back if necessary...

IF NOT EMPTY(lcCont)
	SELECT cont
	CREATE TRIGGER ON cont FOR DELETE AS __RI_DELETE_cont()
ENDIF

Tommy