All, I have the schema: CREATE TABLE panel_tracker (ov_id numeric, mt_acct char(12), orm_id numeric, panel_code char(5));
I would like to create the following INSTEAD OF INSERT trigger: create trigger insteadInsertPanelTracker instead of insert on panel_tracker begin set @ov_id = select ov_id from ov_systems where mt_mnemonic=NEW.ov_id; insert into panel_tracker values (@ov_id, NEW.mt_acct, NEW.orm_id, NEW.panel_code); end ; But I receive the following error: Error: cannot create INSTEAD OF trigger on table: main.panel_tracker Can you assist me in figuring this out? Jerry ________________________________ Disclaimer**** This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of St. Claire Regional Medical Center. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of the email is strictly prohibited. If you received this email in error please notify the St. Claire Regional Helpdesk by telephone at 606-783-6565. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
