Re: Duplicat keys
>
>
>
> I have a problem:
>
> While creating a "unique key index" on a file of about
> 190k records I have incurred a duplicate record. How do I
> find the record(s) with the duplicate key?
>
> We are running Oline 5.0
> 4gl 4.10
> sql 4.10
>
> Thanks in advance for any help.
>
> My e-mail: sheltra@emh-l.submepp.navy.mil
>
>
Ace report:
database xyz end
define
variable hold_key whatever
end
select key from table
order by key
end
format
first page header
let hold_key = '99999999'
on every row
if hold_key = key then print hold_key
let hold_key = key
end
_____________________________________________________________________________
Jack Parker |
Hewlett Packard, BSMC Boise, Idaho, USA| WARNING:
jparker@hpbs3645.boi.hp.com | Do not touch .sig with tongue
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________