Subject | Re: [firebird-support] Re: A bit strange GEN_ID result |
---|---|
Author | Martijn Tonies |
Post date | 2004-02-21T14:44:57Z |
> Yesssssss it's true!!Or use:
>
> This procedure works as I can expect:
>
> CREATE PROCEDURE NEW_PROCEDURE
> AS
> declare variable var integer;
> BEGIN
> select gen_id("Table1_ID_GEN", 1 ) from rdb$database INTO :var;
var = gen_id("Table1_ID_GEN", 1);
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com