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!
