Hi

write a stored procedure and then call

select number from selectprocedure

fr.

Am Montag, 11. Juli 2005 16:48 schrieb German Gonzalez:

> Hello,
>
> I wonder if there is another query to get a key from a generator and
> trigger already declare:
>
> SELECT gen_id(GEN_NAME, 1) FROM rdb$database
>
> I'm having problems with "rdb$database" syntax, actually with the "$"
> character.
>
> thanks in advance.
>
> German Gonzalez
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>