--- In ib-support@y..., Markus Ostenried <chef_007@g...> wrote:

> Nando and John,
>
> thanks for the suggestions. But BREAK and FIRST are both only

availabe

> from FB 1.0 and upper. And some of my customers don't have the

latest

> FB version.

Hi, Markus. I use for a long time BREAK emulation like

Create Procedure GetOne
Returns (...)
As
Begin
For Select .... Into ....
Do Exception I_Found_It;
When Exception I_Found_It Do Suspend;
End

Where I_Found_It is user defined exception.

> If I don't find another way the customers will have to upgrade

sooner

> than I planned to.
>

But this idea is better, I hope :)))

Best regards.