1. What do you mean by large number of records ? 2. Are you sure you dont have any other triggers on either table that are firing as well.
To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Send reply to: [EMAIL PROTECTED] From: "Zhi Liu (ASL)" <[EMAIL PROTECTED]> Subject: RE: [DUG]: 'Connection lost to database' after a trigger fired Date sent: Thu, 28 Aug 2003 15:21:20 +1200 > > > -----Original Message----- > From: Rohit Gupta [mailto:[EMAIL PROTECTED] > Sent: Thursday, 28 August 2003 12:39 p.m. > To: Multiple recipients of list delphi > Subject: Re: [DUG]: 'Connection lost to database' after a trigger fired > > > Its hard to know without more details esp on the triggers for both > tables. You can have circular triggers that will cause this problem. > Interbase/Firebird seems to suddenly decide not to respond either > because its too busy or its terminated the connection because of > over-usage of resources such as memory/virtual-memory. > > Use some proggy like IBVIEW to profile your query and look at the > indexes used, number of records affected and time taken. > > //************************************************************************** > * > > Hi, Rohit Gupta > Thank you for answering my question > > Actually the trigger is quit simple as below. > > SET TERM ^ ; > > CREATE TRIGGER "SAVE_STNDCOLOUR_CHANGE" FOR "STND_COLOUR" > ACTIVE AFTER UPDATE POSITION 3 > AS > BEGIN > IF (NEW.STND_CLR_NAME <> OLD.STND_CLR_NAME) THEN > UPDATE PSL_ORDER > SET ORD_COLOUR = NEW.STND_CLR_NAME > WHERE ORD_COLOUR = OLD.STND_CLR_NAME; > END > ^ > > COMMIT WORK ^ > SET TERM ;^ > > //************************************************************************** > ** > > > To: Multiple recipients of list delphi > <[EMAIL PROTECTED]> > Send reply to: [EMAIL PROTECTED] > From: "Zhi Liu (ASL)" <[EMAIL PROTECTED]> > Subject: [DUG]: 'Connection lost to database' after a > trigger fired > Date sent: Wed, 27 Aug 2003 17:17:47 +1200 > > > Hi, All > > > > I have a D5 app with IB6 db (version 6.0.2.0), the db has two tables A and > > B, I created a trigger (After Update On table B) to update field A in > table > > A. If the number of records to be updated in table A is small, the trigger > > works fine. if the number of records is large, then It works for the > first > > time but fails at the second time with the above error message. > > > > The error occurs on Win XP, Win 98. > > > > Does anyone know what might have caused this problem? > > > > > > > ############################################################################ > ######### > > This e-mail message has been scanned for Viruses and Content and cleared > > by MailMarshal > > For more information please visit www.marshalsoftware.com > > > ############################################################################ > ######### > > > --------------------------------------------------------------------------- > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > Regards > > Rohit > > ====================================================================== > CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand > PH (649) 489-2280 > FX (649) 489-2290 > email [EMAIL PROTECTED] or [EMAIL PROTECTED] > ====================================================================== > > --------------------------------------------------------------------------- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > ##################################################################################### > This e-mail message has been scanned for Viruses and Content and cleared > by MailMarshal > For more information please visit www.marshalsoftware.com > ##################################################################################### > --------------------------------------------------------------------------- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > Regards Rohit ====================================================================== CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH (649) 489-2280 FX (649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] ====================================================================== --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
