Sergey,
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?
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham