No current record for fetch operation

[Ali Erdoğan]

no current record for fetch operation

Arkadaşlar firebird 1.5 ile bir uygulama oluşturmuştum.Ancak bazen kayıt sırasında bu şekilde bir hata alıyorum.Çok ilginçki hatayı tamamen tesadüfi bir anda veriyor ve kullanıcılar zor durumda kalıyorlar.Zor durumda kalınca da beni zor durumda bırakıyorlar. .Ne yapacağım ben bu dertle

[hbahadir]

belki bi yardımı olur.

http://www.visum.lt/FirebirdBugsOpen.html

http://sourceforge.net/tracker/?func=de ... up_id=9028

Confirmed Bug
SELECT * FROM view_det
INNER JOIN view_inv ON view_det.invcod=view_inv.invcod
DOESN'T WORK - No current record for fetch operation. ... and neither will:
SELECT * FROM view_det, view_inv
WHERE view_det.invcod=view_inv.invcod
If you watch the query plan generated by the failing statement, you'll notice it's really big... no surprise since it involves a join of views that in turn are based on other joins. The workaround is to convert
SELECT * FROM view_det
JOIN view_inv ON view_det.invcod=view_inv.invcod
to become
SELECT * FROM view_det
JOIN view_inv ON view_det.invcod-view_inv.invcod=0
or
SELECT * FROM view_det
JOIN view_inv ON view_det.invcod+0=view_inv.invcod
or other variations that fool the optimizer by forcing it to a full scan to do the join. The original statement should work, so this is a bug and the same kind of bug that IB5.X suffered from.

<For full details see original bug report>