At 11:24 PM 24-10-01 +0200, hannes hernler wrote:

>sorry Jason, but to me this seems NOT to be a problem of IB/FB.
>
>the SP is working.
>when I call it from IB_storedprocedure everything is fine.
>when I call it from ib_cursor it is executed twice.

Hannes,
Did you discover what is the effect of calling First on that SELECT statement, instead of EXECUTE?

I would be astonished if you were able to do this interactively:

execute procedure select * from myproc(arga, argb)

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________