Thanks for your thoughtful questions.

> Does the import code call the generator to get the ID for each
> record it imports or does it only do it once in the beginning
> to get the starting ID and then just increment that number
> internally when importing the records?

It calls the generator each time to get the ID--the exact code was
posted above, but here is how the local variable is assigned:

lPersonID := FIBConn.Gen_ID('GEN_PERSON_ID', 1);

the method inserts one record into the database. It will be called
again to insert a new record when an additional record needs to be
inserted.

I can do this and it will work fine every time. I have only seen this
problem a couple of times with my users--and I have no idea why
(logging is turned off by default, it slows the application down).

> Also, I'm getting a little confused on the relation between the
> importing code and the IBO dataset where you have
> generatorlinks set. Do you use that particular dataset to insert
> the records or do you do the inserts in a standalone query using
> parameters that are prepared?

GeneratorLinks is set at the connection level, with the same
connection used for imported data and editing data.

But I create TIB_DSQL objects to insert the records that exist in a
utility for importing records. I don't use TDataset decedents for
this--it is a whole lot faster then the databound control. (Thousands
of records can be imported in one import, which is fairly quick with
TIB_DSQL).

Ed Dressel