My command creates a cursor with all the duplicates. You can use this cursor to change the records in the tty table, but I don't have the time to do it for you.
>i try ,but not works...bad try and thinking
>
>CLOSE all
>USE tty in 0
>INDEX on ncli TO gg
>Select tty.telno,tty.typ from tty group by tty.telno,tty.typ having count(*)>1 READWRITE
>replace typ with 1
>
>
>>Then you must add some more code....
>>
>>>thank you,it works
>>>but i need to replace my field typ with 1 where records is duplicated
>>>at mytable. or insert all duplicated records to newtable.
>>>
>>>
>>>
>>>
>>>>Sorry, it was a type
>>>>Select tty.telno from tty group by tty.telno having count(*)>1
>>>>
>>>>>hi,
>>>>>thank you for reply,
>>>>>error message SQL: HAVING clause is invalid
>>>>>
>>>>>
>>>>>>>hi all,
>>>>>>>
>>>>>>>i try as under to finde the duplicted records, not works any idea
>>>>>>>thanks
>>>>>>>
>>>>>>>CLOSE all
>>>>>>>USE tty in 0
>>>>>>>m.telno=telno
>>>>>>>INDEX on telno TO gg
>>>>>>>
>>>>>>>SCAN FOR telno==m.telno
>>>>>>> IF FOUND()
>>>>>>> replace typ WITH 1
>>>>>>> ENDIF
>>>>>>>ENDSCAN
>>>>>>>brow
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>thanks
>>>>>>
>>>>>>To locate the duplicates, you can use this code.
>>>>>>Select tty.telno from tty group by tty.telno having count(*)