-----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/
