On Thu, 2005-02-10 at 23:59 +0100, Witold Czarnecki wrote:
> sqlite> CREATE TABLE test(a NUMERIC);
> sqlite> CREATE TRIGGER test1 BEFORE INSERT ON test FOR EACH ROW BEGIN
> ...> SELECT CASE WHEN (TYPEOF(NEW.a) != 'numeric') THEN RAISE(ABORT,
> 'Error!') END;
> ...> END;
> sqlite> INSERT INTO test VALUES('aaa');
> sqlite> SELECT TYPEOF(a) FROM test;
> numeric
> sqlite>
>
> Why this trigger doesn't fire?
>
I tired the above (using copy/paste) and the trigger
did fire. What version of SQLite are you running?
--
D. Richard Hipp <[EMAIL PROTECTED]>
