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:

IF (NEW.ID IS NULL)
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
http://www.upscene.com

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