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(*)