Re: Error:741: Trigger for the same event already exists.

R Did you try UPDATE STATISTICS? HTH Sujit RSmith@iiug.org (R Smith) on 03/23/2000 07:01:55 PM Please respond to RSmith@iiug.org (R Smith) To: informix-list@iiug.org cc: Subject: Error:741: Trigger for the same event already exists. Hmmm... well, this one is keeping me up late tonight. Today, I have been working on new/old procedures and triggers and as I was updating the database, I ran into the -741 error. This happens to be a trigger that I did not modify, so it's more mystifying than usual. I simply added a 'drop trigger' statement before the 'create' and now I am being told that the trigger already exists. When I execute the 'drop trigger' statement, I get the following error: 634: Object does not exist. 111: ISAM error: no record found. ... so what's the deal? It's not there on the drop and it exists on the create?? Then, I got fancy, and may have dug myself a bigger hole. There were references to the original trigger in systriggers and systrigbody, so I deleted them. Guess what? No difference!! I'm not sure where to go from here if I can neither delete or create it. Any help would certainly be appreciated. drop trigger "exedor".rej_insert; create trigger "mediator".rej_insert insert on "exedor".reject_info referencing new as pre for each row ( execute procedure "exedor".insertrejaudit(pre.reject_id, pre.wf_id ,pre.case_id ,pre.case_solution_id, pre.switch_id ,pre.so, re.tn ,pre.rj_dt_tm ,pre.last_update, pre.retry_counter ,pre.output_msg, ,pre.action_seq ), execute procedure reject_received (CURRENT), execute procedure insert_wf_link (pre.wf_id, pre.reject_id, "R") ); -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----