At 07:39 AM 18/12/2007, amoradell wrote:

>Hi,
>
>1 - select (gen_comuni_id,0) from rdb$database : value
>2 - insert record in columni without value for mycode
>3 - select (gen_comuni_id,0) from rdb$database : value
> should have changed !

These statements are not valid syntax. You cannot invoke the GEN_ID() function by supplying the arguments on their own.

for example, above #1 should be:

select GEN_ID(gen_comuni_id,0) from rdb$database

and that will return the last value that was generated.

./hb