Hi "Andrei Babyuk",

First please post these messages to fb-devel instead of firebird-support,
thanks.

Subject: [firebird-support] Error: "no current record for fetch operation"

> I get this error when running the query below in Firebird 1.5 RC3.
> The same query on the same data works fine in Interbase 6.01.

SELECT
t2.EE_NBR, t4.CO_NBR, t3.AMOUNT, t4.WORKERS_COMP_WAGE_LIMIT,
t3.RATE_NUMBER, t3.CL_E_DS_NBR, t5.E_D_CODE_TYPE
FROM
Pr_Check_Hist('now') t2,
Pr_Check_Lines_Hist('now') t3,
Ee_Hist('now') t4,
Cl_E_DS_Hist('now') t5
WHERE
t2.PR_CHECK_NBR = t3.PR_CHECK_NBR AND
t5.CL_E_DS_NBR = t3.CL_E_DS_NBR AND
t2.PR_NBR = 5 AND
t4.EE_NBR = t2.EE_NBR AND
t3.PR_NBR = 5 and
t5.E_D_CODE_TYPE LIKE 'E%'

> Clearly it has something to do with joined stored procedures, because
> if I use real tables instead, the query executes without errors.
> Looks like a Firebird bug???

Can you also post the PLAN generated with this query.
Stored Procedures in the from clause are always an special case, but ...
I've changed something related to this after the RC3 release. When it is
possible to send a compressed backup-file to me directly or an DDL-script to
reproduce your problem i would be happy. It could be that it's already fixed
in the current CVS-tree.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81