ok.
thank you very much.
>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(*)