Subject Re: [firebird-support] Re: Listing current generator values, execute statement
Author Bob Murdoch
At 1/29/2004 09:45 AM, Alexander V.Nevsky wrote:

> No, EXECUTE STATEMENT don't make type conversions and don't know
>what the type is returned by gen_id. Use explicit Cast:
>
>execute statement 'select Cast(gen_id(' || generator_name || ',0) as
>Integer) from rdb$database'

Ah. Darn it. Should have figured that one out myself. That definitely
works. Thanks.

Bob M..