At 03:01 AM 13/05/2004 +0000, you 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.

Hmmm, well, that's certainly not the issue. You have exactly *no* input
parameters here and it is a teeny little statement.

Those deeply nested master-details might, though. Have you used the
IB_MonitorDialog to keep an eye on the statements that are being sent
through to refresh those M-D-D-D structures? You should be able to see the
statements before the exception occurs.

/heLen