> if I try to execute the folowing query I receive "Connection lost"
> exception:
>
> select 1 from Table1
> where
> exists (select field1 from View1
> where <some conditions>
> )
>
> View1 is a view. If I exchange it with a table in the query
> everything works fine.
>
> I'm using Firebird 1.0.2

If the view uses one or more UNIONs, then this is a known
bug in Firebird 1.0.x and has been fixed in FB 1.5.


Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com