I did not see my post appear on the list, so I am sending it again.

Ronan

----- Original Message -----
From: Ronan van Riet
To: IBObjects@yahoogroups.com
Sent: Sunday, January 11, 2004 1:49 AM
Subject: Re: [IBO] getting sequence val before insert


Hello Paul,

The problem is fixed. I was letting the trigger generate the sequence, but by calling GEN_ID( my generator) it was incremented once too often hence the -1 subtraction.

Thanks,
Ronan van Riet

[Non-text portions of this message have been removed]