Instead of Triggers in SQLite
I want to use Triggers in views. How can I do that with Instead of Trigger
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Javeed M ShaikhPosted Nov 4, 2011, 11:36 AM
CREATE TRIGGER MyViewTrig_On_insert INSTEAD OF INSERT ON MyViewName
BEGIN
INSERT INTO tempdata (id , morecolumns) VALUES (new.id, new.morecolumns);
END;