Subject | Re: [firebird-support] Re: Listing current generator values, execute statement |
---|---|
Author | Bob Murdoch |
Post date | 2004-01-29T15:04:29Z |
At 1/29/2004 09:45 AM, Alexander V.Nevsky wrote:
works. Thanks.
Bob M..
> 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'
works. Thanks.
Bob M..