> Yes, I have struck this issue, my solution was to create a view of the 4

or

> so which do work, and make the final join with the view.
> Not sure what caused it but the view solution worked for me

Does FB1.5 also crash on this?

Better make the DB public to a developer or at least the
relevant tables and get the error fixed.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> Alan
>
> > -----Original Message-----
> > From: Andreas [mailto:andreasfurrer@...]
> > Sent: Friday, 27 June 2003 7:56 PM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] Connection to firebird server 1.02/1.03
> > dropped on complex SQL-Query
> >
> >
> > I have a complex SQL-Query (using Delphi with BDE) with a lot of
> > sub-queries. The query is a UNION of 5 select statements.
> >
> > If I execute the command the connection to the firebird server is
> > immediately dropped.
> >
> > If I reduce my query to only 4 select statements, the query works.
> >
> >
> > Are there any parameters (server side or client side) which I need to
> > change? Or what else can I do?
> >
> >
> > Thanks from Germany.
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
> >
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>