Hi all,

in a trigger I have a select statement like

select Key, Field from Tbl where ...
order by Field desc

I want to store the value of "Key" in a variable of
the trigger. But only for the first record.

I need to get the Key-Value of the record with Max(Field)
but unfortuantely Field is not unique and I cannot write
Select Key, Max(Field) from....

I remember that there was an answer sometimes ago
that suggested to somehow use rdb$database in the select
statement to only get one single record.

Can anybody help ?

TIA,
Markus