Hi,

This is something unusual. For the record, I'm using Firebird 1.0.0.794
(Official release 1.0)

Here's the error message:

"ISC ERROR CODE:335544343

ISC ERROR MESSAGE:
invalid request BLR at offset 205
context already in use (BLR error)"

Here's the query:

SELECT DISTINCT
INVOICE.INSURANCECONO,
CLIENTORDER.INSURANCE_TOTAL,
CLIENTORDER.INSURANCEBALDUE,
CLIENTORDER.CLIENTNO,
CLIENTORDER.ORDERNO,
CLIENTORDER.INVOICEDATE,
INSURANCE.COMPANYNAME,
(SELECT FULLNAME FROM CLIENTFULLNAME_1(2, CLIENTORDER.CLIENTNO)) AS
C_FULLNAME
FROM Invoice
INNER JOIN ClientOrder
ON (INVOICE.orderno=CLIENTorder.orderno)
INNER JOIN INSURANCE
ON (INSURANCE.COMPANYNO=INVOICE.INSURANCECONO)
WHERE ((CLIENTORDER.INSURANCE_TOTAL <> 0) AND
(CLIENTORDER.INVOICEDATE <= :"End Date"))
Order By INVOICE.INSURANCECONO

The problem started after inserting the "(SELECT FULLNAME FROM
CLIENTFULLNAME_1(2, CLIENTORDER.CLIENTNO)) AS C_FULLNAME" line in the
query. I've used this line in other queries with
success. "CLIENTFULLNAME_1" is a stored procedure. I can even change
CLIENTORDER.CLIENTNO to an integer value without any success. I've tried
running this query in QuickDesk and IB_SQL without success.

Thanks in advance for any help.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)