>>>>
>>>>You can run following query to find duplicate keys that already exist in the view
SELECT cv.* FROM (cView) cv
>>>> JOIN (cTable) ct
>>>> ON ct.own_Owner_Code = cv.own_Owner_Code
>>>> AND ct.typ_Customer_Type = cv.typ_Customer_Type
>>>>
>>>
>>>
>>>That doesn't work because cView is a remote view of a SQL Server table and cTable is a VFP table. But, I did check and discovered there are a number of records in the SQL Table that I wasn't aware had been entered, so that's probably the problem.
>>
>>It certanly will work with remote view and VFP table. What seems to be a problem (besides ';' that I ommited)?
>
>Sorry Sergey, you're absolutely right. Works just fine as listed, adjusting for the ;s. Just didn't work in a SQLEXEC() function - duh!
No problem. :)
--sb--