>>>>> On Mon, 4 Nov 2002 23:55:27 +0100 (MET), Paul Vinkenoog <paulvink@...> said:

PV> That's because you SELECT from an _executable_ SP. Executable
PV> SPs don't return a dataset, they return output values. I just
PV> dropped an IB_StoredProc onto a form, had it execute your SP
PV> and it returned the data in the output fields.

Yes, you are right. I still do not understand reasoning behind the
different behaviour, and will investigate if one is faster than the
other :)

PV> BTW: Marco: perhaps in your case it didn't work without the
PV> SUSPEND because you had the StoredProcForSelect property of
PV> the IB_StoredProc set to true. In my experience (with both IB
PV> and FB, IBO 3.x and 4.x) TIB_StoredProc works like it's
PV> supposed to.

You hit another gray area: Jason himself explained it long time ago,
but I never catched the point of that property.

Just another little brick that finds its place in the wall :)

bye&thanx,
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.