At 06/03/2002 04:21 AM (Monday), Svein Erling Tysvær wrote:

>Generators are not subject to transaction control, so there is no guarantee
>that using gen_id(Partner_id, 1) will yield two consecutive numbers when
>issued twice within a trigger. Rather than using gen_id twice, use it once
>assigning it to a variable and then use this variable when inserting into
>tables/views.

Just to be clear: The original code used a gen_ID(Partner_id,1) followed by
a gen_id(Partner_id,0) to retrieve the same value a second time. However,
Set's advice above applies equally well to this situation. In fact, it is
required for the intent of the original code to be realized reliably.