Subject Re: [ib-support] select single row only
Author Lucas Franzen
Markus Ostenried schrieb:
> 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.
> If I don't find another way the customers will have to upgrade sooner
> than I planned to.


you can wrie a stored procedure that will look for the values in a loop (and will exit immediately after the suspend) and call
this procedure from within your trigger.