> >SET GENERATOR GEN_NEW_AUTHOR_ID TO (SELECT MAX(AUTHOR_ID) FROM AUTHOR);
> >
> >I have data that I have migrated from Paradox to InterBase. I am

currently

> >writing a script with all the updates that I am making to the data, as I
> >will have to go through this process again.

> Were the Author records committed before you tried to select

max(AUTHOR_ID)?

Yeah, the records are all committed. The migration was done separately from
this work I'm doing now on the data.

Stephen