Subject RE: [IBO] Duplicating rows
Author Helen Borrie (TeamIBO)
At 03:10 PM 04-03-02 +0200, Riho-Rene Ellermaa wrote:
>I don't have any triggers in database, I have GeneratorLinks. If I don't
>change ID value, then after Insert() and setting RowData I get "Key
>violation", when trying to Post(), because RowData contains also the
>source records ID.
>Do you mean that I must put Before Insert triggers everywere?

No!! I was just establishing whether, if you do have triggers, they are
causing the double-dipping on your generators.

I just can't see why, if you are using GeneratorLinks, you are also
applying those values manually. If you use GeneratorLinks, you don't code
anything for them. If you are fetching the generator values yourself, then
you are double-dipping.

if you are going to use RowData, don't use GeneratorLinks at all. Instead,
call Gen_ID() in the BeforePost event to get those generator values and
write them into your ID and Docnum fields.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at