Subject Re: [IBO] Generator values not udpated
Author Woody
From: "Ed Dressel" <dressel@...>
>> a) If you have GeneratorLinks set for this table (either at dataset
>> level or at connection level) then IBO is already calling Gen_ID()
>> and assigning a fresh value to the **parameter** during the
>> BeforeInsert event
>
> This sounds like it must be related to this--I do have GeneratorLinks
> set at the connection for table and the ID's causing the problem. But
> it only causes the problem occasionally.
>

Ed,

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?

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?

Woody (TMW)