Subject | Re: [IBO] Generator values not udpated |
---|---|
Author | Ed Dressel |
Post date | 2008-11-07T17:20:32Z |
> a) If you have GeneratorLinks set for this table (either at datasetThis sounds like it must be related to this--I do have GeneratorLinks
> level or at connection level) then IBO is already calling Gen_ID()
> and assigning a fresh value to the **parameter** during the
> BeforeInsert event
set at the connection for table and the ID's causing the problem. But
it only causes the problem occasionally.
I do need the ID in the import utility for detail record IDs--that is
why I calling Connection.Gen_ID('GEN_NAME', 1)--am using the value.
So trying to determine what is happening and a solution:
1) Why might this be only happening occasionally?
2) I could clear all of the generator links while the data is being
imported, then restore it--but I really don't like doing that. Is
there another option? For example, can I explicity turn off generator
link settings for the dsql performing the insert?
Thanks.