Hi,

How did you create the Stored Procedure?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> 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++ ;)
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>