Help please!
on how to drive a stored proc to produce a dataset.
I have written a stored procedure which ends as
"
result = A - B;
suspend;
end
"
which seems to work while testing

In the calling program I put
mystoredproc.prepare;
mystoredproc.parambyname(...) := etc

MyStoredProc.open
while not mystoredproc.eof do
begin
do something;
end;

But does the stored proc produce an eof ?

When I say OPen it seems to be getting the whole dataset before I can
catch it !

SO I tried
while not myanswer = null do
mystoredproc.execute;
myanswer := mystoredproc.result;
That does not seem to work either

will happily post the stored proc and the little test program if it
helps.

Regards Dave