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.

Markus,

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

Luc.