--- In ib-support@y..., Paul Reeves <paul@f...> wrote:
> Didier Gasser-Morlay wrote:
> >
> > Now my question: I am trying to create a primary key with three
fields :
> > FieldA, FieldB and FieldC. The three fields are not null obviously. In
> > my mind, the uniqueness is evaluated by combining the three fields
> > values and the result must be unique. It seems though that as soon as
> > fieldA has got the same value in more than one record, then the PK
> > creation is rejected.
> >
>
> What do you mean by 'the PK creation is rejected'? Is the DDL statement
> rejected or the insert statement rejected?
>
There are already 3 records inthe table
1st record FieldA = 'independent', FieldB = 37, FieldC= 7
2nd record FieldA = 'independent', FieldB = 3, FieldC= 0
3rd record FieldA = 'IOS', FieldB = 6, FieldC= 1

When atempting to create the PK, the message is
ISC ERROR CODE:335544349

ISC ERROR MESSAGE:
attempt to store duplicate value (visible to active transactions) in
unique index "RDB$PRIMARY48"
null segment of UNIQUE KEY

FYIW
Didier