|Subject||Re: [firebird-support] Re: Listing current generator values, execute statement|
At 1/29/2004 09:45 AM, Alexander V.Nevsky wrote:
> No, EXECUTE STATEMENT don't make type conversions and don't knowAh. Darn it. Should have figured that one out myself. That definitely
>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'