hi,

i need your help to delete the duplicted record first at field ClientNo second at field name,

another thing, if you can help me to insert the all duplicted records at new table,and deleted(zap) form the old table.

use myTable exclusive
index on ClientNo tag ClientNo
select sys(2015) as SortOrder,* from myTable ;
 order by 1 descending ;
 into cursor crsTemp nofilter
select myTable
zap
select crsTemp
scan
 if !seek(ClientNo,'myTable','ClientNo')
   scatter memvar memo
   insert into myTable from memvar
 endif
endscan

thank you.

,
>>hi,
>>
>>i mean in mytable(aa) i have field(client no) ,(client no) duplicated many time ,i need
>>(clint no) as a one record in mytable(aa),
>>
>> i dont want to use new table
>
>

>use myTable exclusive
>index on ClientNo tag ClientNo
>select sys(2015) as SortOrder,* from myTable ;
> order by 1 descending ;
> into cursor crsTemp nofilter
>select myTable
>zap
>select crsTemp
>scan
> if !seek(ClientNo,'myTable','ClientNo')
>   scatter memvar memo
>   insert into myTable from memvar
> endif
>endscan
>

Cetin