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