How to return custom error code in sqlite3?

Question

I have a trigger statement like this:

CREATE TRIGGER update_customer_address UPDATE OF address ON customers 
  BEGIN
    UPDATE orders SET address = new.address WHERE customer_name = old.name;
    -- RAISE ...
  END;
END;

EDIT:

I want to do a step:

int result = sqlite3_step(statement);

I know result returns the result code like SQLITE_DONE, SQLITE_ROW, and SQLITE_CONSTRAINT. I also discovered that RAISE ABORT within TRIGGER returns SQLITE_CONSTRAINT to result.

Is there a way for me to create a custom error code? I want to do something like

int result = sqlite3_step(statement);
// get custom error code here

Is it possible to raise with a custom error code in sqlite? Or are there any workarounds?

mbarthelemy · Accepted Answer · 2012-10-03 06:41:24Z

5

You can throw an error using the RAISE() function. You have to use pre-defined error codes (IGNORE, ABORT, FAIL or ROLLBACK) but you can add a custom message:

CREATE TRIGGER update_customer_address UPDATE OF address ON customers 
BEGIN
  UPDATE orders SET address = new.address WHERE customer_name = old.name;
  SELECT CASE
    WHEN ( (SELECT * from orders WHERE address = 'old address!!') IS NOT NULL)
    THEN RAISE (FAIL, 'Can still find old address, not everything was updated!')
  END;
END;

Note that RAISE() is meant to be used only when something was wrong, see the doc for more information about raise() behavior.

answered Oct 3, 2012 at 6:41

mbarthelemy

13k4 gold badges44 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Irfan · Accepted Answer · 2017-09-05 10:44:35Z

-1

Yes ofcourse you can define custom error codes or messages. All messages sent by

raise(ERR, "message")

can be retreived in C/C++ through

const char *sqlite3_errmsg(sqlite3*);

answered Sep 5, 2017 at 10:44

Irfan

2,7693 gold badges30 silver badges43 bronze badges

Collectives™ on Stack Overflow

How to return custom error code in sqlite3?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related