Subject | Problem creating UNIQUE index.. |
---|---|
Author | mk_delphi |
Post date | 2002-11-12T10:53:06Z |
Hi All,
I have a problem creating a unique index on
an existing table, FB show an error:
no 2 rows.... indicating duplicated values
bute there are no dups, the next query
show no more then 1 on sum:
select BARCODE,NR_ORDINE,COUNT(*) from BARCODE
GROUP BY BARCODE,NR_ORDINE
the index is : BARCODE,NR_ORDINE
Can someone help me?
Sincerely yours,
Marco
I have a problem creating a unique index on
an existing table, FB show an error:
no 2 rows.... indicating duplicated values
bute there are no dups, the next query
show no more then 1 on sum:
select BARCODE,NR_ORDINE,COUNT(*) from BARCODE
GROUP BY BARCODE,NR_ORDINE
the index is : BARCODE,NR_ORDINE
Can someone help me?
Sincerely yours,
Marco