I sent you a short documentation that I've written via e-mail (in German language) to your e-mail address. Maybe that notice can help you.

-----Ursprüngliche Nachricht-----
Von: Christian Gütter [mailto:friesenpower@...]
Gesendet: Dienstag, 17. Februar 2004 12:08
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] ISC ERROR CODE:335544781 ISC ERROR CODE:335544781 ISC ERROR CODE:335544781 'ISC ERROR CODE:335544781 'ISC ERROR CODE:335544781 'ISC ERROR CODE:335544781 ISC Error Code:335544781/Stack overflow


Hi,

when updating a certain dataset, I the following error message is displayed

ISC ERROR MESSAGE:
Stack overflow. The resource requirements of the runtime stack have exceeded the memory available to it.

I was able to find out that this error is caused by the following update statement
which is executed by a trigger:

UPDATE T_Pa_Pos_Cm_Ergebnisse
SET Vertrag_gefunden = NEW.Vertrag_Gefunden,
[...]
Ergebnis_Gilt_Fuer_Gruppe = NEW.Ergebnis_Gilt_Fuer_Gruppe
WHERE PA_Pos_Zuordnung IN (
SELECT ID FROM T_Pa_Pos_Cm WHERE Plan_Ref_Number IN (
SELECT Plan_Ref_Number FROM T_Pa_Pos_Cm WHERE ID = NEW.Pa_Pos_Zuordnung));

The two subselects in the WHERE clause _always_ return less then 10 records,
so I am wondering why this statement causes a stack overflow and if there is
a way to work around it.
I am using Firebird 1.03.

It would be great if somone could shed some light on this.


TIA,

Christian




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]