What is the value of cMyTableName? It should be an alias not a table name.
>I wanted to ask you if I use your suggestion correctly, since I am getting strange results.
>
>My SQL looks like this:
>
>
>SELECT * FROM (cMyTableName) ;
> WITH (Buffering = .T.) ;
> WHERE MYFLD = cUserEntry ;
> TO SCREEN NOCONSOLE
>
>
>
>The strange results I get is if the table has 1 record and I add another record with the same entry, the code above does not catch it. If I add 3rd record with the same entry, then the code finds the duplicate record. Can you think of why I get these results?
--sb--