On Thu, Feb 9, 2012 at 4:05 PM, Si Carter <s1cart3r@...> 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
>
>
>