Stop all sessions,
stop databases
restart in single user mode
repeat it - this will work.

Claus

mk_delphi wrote:

>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
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>.
>