Dynamic SQL Error
SQL error code = -206
Column unknown
PENZTBIZFAJTA
At line 5, column 39
-----------------------------------------------------------------------------

select A.*,
(select PenztBizFajta from GET_PENZTBIZCSOP_ADAT(A.PenztBizCsopAzon,
A.PenztBizCsopValt)) as PenztBizFajta,
(select sum(Osszeg) from PENZTBIZTET T where T.PenztBizFejAzon =
A.PenztBizFejAzon) as BizOsszesen
from PENZTBIZFEJ A
where (A.KELTE between :KELTE_TOL and :KELTE_IG) and (PenztBizFajta =
'B') and (A.PenztarAzon = 1000000001)
order by BizSzam


-----------------------------------------------------------------------------
-----------------------------------------------------------------------------

If I delete the (PenztBizFajta = 'B') part of WHEN text, the result set
correct (inside PenztBizFajta column)

I try it with IBX and IBOConsole in both FB 1.5 and FB 1.5.1.

eMeL


ps.
Sorry my terrible English. My native language is C/C++ ;)