>>Try

* VFP9 only
>>SELECT * FROM  mytable ;
>>	WITH (Buffering = .T.) ;
>> 	WHERE <New User Entry> ;
>> 	TO SCREEN NOCONSOLE
>> 	
>>IF _TALLY > 1
>>  * Duplicate
>>
>>*Any VFP version
>>COUNT FOR <New User Entry> to nCount
>>GOTO (nCurrenRecno)
>>IF nCount > 1
>>  * Duplicate
>>

>
>Hi Sergey,
>
>Thank you very much. I will try your suggestion. Just looking at your code I see syntax "WITH (Buffering = .T.)" which I have never seen. Interesting.
>
>Again, thank you.

You may also check Re: Select WITH Buffering = .t. Thread #1136217 <g>