moorefg wrote:

>Thanks Helen.
>
>We are using Firebird 1.5 though the issue has been with Firebird
>1.0 as
>well.
>
>We do not use blob parameters.
>
>Using IB Objects we do use the embedded Select and we have a
>suspicion that
>this may be an issue.
>
>Otherwise our queries are pretty simple - Mostly Master - Detail.
>The most
>complex may have links between four tables.
>
>The common embedded select takes the following form.
>
>Select field1,
> (Select Surname || ', ' Title || ' ' || Initials from
>people
>where policy.customerid = customer.customerid) as Member_Name
> ,Field2
> ,Field3 etc
>
>Any further assistance would be gratefully received as we have a
>great
>application spoilt by this issue.
>
>Francis
>
>
>

Francis,

Could you monitor the real statment send to the server and identify each
one is causing the problem ?

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br