>>>>> On Mon, 04 Nov 2002 13:30:46 -0000, "Marco Menardi" <mmenaz@...> said:

MM> well, I've tried with a different SP, that does not have FOR
MM> SELECT..., it does a select and puts the value in the return
MM> variables. No, without the final SUSPEND it does not work
MM> (return values) using IB_StoredProc. So, or it's a
MM> IB_StoredProc bug, or there is something we are missing...

Marco, do you mean that using a different component, you got it
working ok "without the final SUSPEND"??

Think at SUSPEND as the equivalent of "return value" in C (where
"value" is actually a whole tuple, a single record in DB parlance), or
better the "yeld" keyword in Python: without it (that is, when you
reach the end of your SP, with or without an explicit EXIT) there is
nothing coming back from the server: all components should give you an
EOF status, I would be very surprised if this is not the case.

hth,
bye, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.