> This is not just happening in one transaction,
>
> I open a new isql session and I see the 2 records.
>
> I run: gfix -commit all
>
> and opened a new isql and I still see the 2 record.
>
> This means that the database actually has the 2 records, correct?
>
> thanks,
>
> stan
>

can you check if the unique constraint is active?
Alan