Subject Re: [ib-support] select single row only
Author Markus Ostenried
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.

Anyway, thank you both,

>use a FOR SELECT ... INTO and jump off the loop (is that BREAK?) after
>the first occurrence.
> ____

>The unique value issue notwithstanding this might be a good place to try
>the new Firebird FIRST keyword. The SQL would look something like:
>select first 1 key, field from tbl where ... order by ... into :var1,