>>How do I check for duplicate in table buffered mode? Do I have to do a 'COPY TO' a temp table before I check? It seems troublesome.
>>
>>This table buffering is really killing my time. Can someone please comment?
>
>This is an interesting situation. I don't think a COPY TO is good as it will slow down the process on big tables. Are candidates keys useful in this situation? This process may be handle by Visual FoxPro automatically using that. Or, if from a manual process, then I would check for all modified records in comparism with the rest of the table.
>
>There is certainly other techniques. Those are just the first ones that came to my mind.

I am puzzled. Isn't this a basic thing everyone using VFP will encounter? How do you people normally handle duplicate key in table buffer mode? Using the candidate key? The second method sounds like quite a chore.