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]