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

From: RSmith@iiug.org (R Smith) > >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!! Have you tried running an oncheck -cDI on the system catalogs? Hope this Cures it. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

>Have you tried running an oncheck -cDI on the system catalogs? Hope this >Cures it. >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > Obnoxio, that did the trick ... whew! Many thanks. -----= 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! =-----