| Subject | cancelling a trigger | 
|---|---|
| Author | Bill Meaney | 
| Post date | 2002-05-14T20:53Z | 
How can I cancel the execution of an operation before the operation takes
place, with a trigger?
CREATE TRIGGER CancelDelete FOR myTable BEFORE DELETE POSITION 1 AS
BEGIN
IF (someDoNotDeleteCondition = TRUE) THEN
BEGIN
/* cancel the delete operation here */
END
END
Is it even possible?
Bill Meaney
wameaney@...
[Non-text portions of this message have been removed]
            place, with a trigger?
CREATE TRIGGER CancelDelete FOR myTable BEFORE DELETE POSITION 1 AS
BEGIN
IF (someDoNotDeleteCondition = TRUE) THEN
BEGIN
/* cancel the delete operation here */
END
END
Is it even possible?
Bill Meaney
wameaney@...
[Non-text portions of this message have been removed]