2015-05-25 15:27 GMT+03:00 Richard Hipp :
>
> https://www.sqlite.org/mark/lang_createtrigger.html?Cautions+val*ger.#mark
>
Missed that. Thanks!
--
Tomash Brechko
See:
https://www.sqlite.org/mark/lang_createtrigger.html?Cautions+val*ger.#mark
On 5/24/15, Tomash Brechko wrote:
> Hello,
>
> The following code
>
> -- beg --
> CREATE TEMP TABLE t (pk INTEGER PRIMARY KEY, i);
> CREATE TEMP TABLE b (before_pk, i);
> CREATE TEMP TABLE a (after_pk, i);
>
>
Hello,
The following code
-- beg --
CREATE TEMP TABLE t (pk INTEGER PRIMARY KEY, i);
CREATE TEMP TABLE b (before_pk, i);
CREATE TEMP TABLE a (after_pk, i);
CREATE TEMP TRIGGER tb BEFORE INSERT ON t FOR EACH ROW
BEGIN
INSERT INTO b VALUES (NEW.pk, NEW.i);
END;
CREATE TEMP TRIGGER ta AFTER
3 matches
Mail list logo