On Thu, Feb 9, 2012 at 4:05 PM, Si Carter <[email protected]> wrote:
> Worked a treat thankyou > If you plan to use this in a multi-user environment, do test it there too. Good luck, Ann >> >> EXECUTE BLOCK >> AS >> DECLARE VARIABLE vMaxID INTEGER; >> DECLARE VARIABLE Dummy INTEGER; >> BEGIN >> SELECT MAX(PK_TABLE_B) FROM TABLE_B >> INTO :vMaxID ; >> DUMMY = GEN_ID(TABLE_B_GEN, :vMaxID - GEN_ID(TABLE_B_GEN, >> -GEN_ID(TABLE_B_GEN,0))); >> END ^ >> >> The inner GEN_ID will set the generator to 0, the outer to vMaxID. >> >> HTH, >> Set >> >> __._, >> > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > >
