Cause an insert or update to fail based on code in a trigger in SA12

1	Based on code in a trigger I want to stop the insert or update that triggered it to fail. Since this is an atomic statement, can this be done at the database level? failure trigger asked 15 Jul '13, 12:17 judy 46●2●2●4 accept rate: 0% flat view

One Answer:

active answers oldest answers newest answers popular answers

Just call ROLLBACK TRIGGER within the trigger under the according condition.

To cite from the docs:

The ROLLBACK TRIGGER statement rolls back the work done in a trigger, including the data manipulation that caused the trigger to fire.

Optionally, a RAISERROR statement can executed. If a RAISERROR statement is executed, an error is returned to the application. If no RAISERROR statement is executed, no error is returned.

If a ROLLBACK TRIGGER statement is used within a nested trigger and without a RAISERROR statement, only the innermost trigger and the statement which caused it to fire are undone.

permanent link

answered 15 Jul '13, 12:26

Volker Barth
40.2k●362●550●822
accept rate: 34%

...and here's an example: http://sqlanywhere.blogspot.ca/2009/02/one-row-only.html

(15 Jul '13, 13:15) Breck Carter

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

trigger ×79
failure ×12

question asked: 15 Jul '13, 12:17

question was seen: 2,471 times

last updated: 15 Jul '13, 13:15

SAP SQL Anywhere

Cause an insert or update to fail based on code in a trigger in SA12

Follow this question

Related questions