Subject Re: [ib-support] Setting a generator to the maximum value of the primary key
Author Helen Borrie
Post date 2001-10-05T14:39:46Z
At 02:48 PM 05-10-01 +0200, Luc Franzen wrote:

>you might try:
>
>SELECT GEN_ID ( GEN_NEW_AUTHOR_ID,
> ( SELECT MAX ( AUTHOR_ID ) FROM AUTHOR ) + 1 )
>FROM RDB$DATABASE

COOL, Luc!!

H.

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________