Thanks Frank..
That worked!

>
> what happens when you change the sp to:
>
> BEGIN
> FOR SELECT var1, var2, var3
> FROM TABLE
> WHERE condition = condition1
> INTO :return1, :return2 , :return3
> DO BEGIN
> SUSPEND;
> EXIT;
> END
> EXIT;
> END
>
> (untested, just "from the hip")
>
> in your example you use a simple Select, and a Suspend afterwards.

So afaikt the

> sp *must* return at least one row. with the FOR Select loop, if no

records are

> found, nothing is returned, so you should get an eof directly - i

hope ;-)

>
> regards & hth,
> fingerman
>
> --
> -------------------------------------------------------------------

------

> when parsers parse, and compilers compile, then why don't objects

object?

>
> fingerbirdy - fingerman's door to Firebird
> http://www.fingerbird.de