Subject Re: [firebird-support] Is it possible to suspend a generator?
Author Martijn Tonies
Hello Neil,

> I need to insert some data with fixed IDs. The table that I am inserting
> into already has data and a generator for the IDs. The new data is below
> the value of the generator and the IDs do not already exist. Can I suspend
> the generator while I insert these new rows and if so how?

The generator itself doesn't do anything, it's probably a trigger on the
table that fetches a new value.

If the trigger is in the form of:

THEN ... fetch new value and use it ...

it should work for your case, if not, I suggest you modify the trigger.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!