Hi All,

I am getting error 1547 "Cannot insert an empty row from a view into its base table(s)" and I don't see why. PLEASE HELP!

This same view works flawlessly using VFP tables, however, when I change it to a remote view (SQL Server) VFP fires error 1547.

The view updates the Mc_PcpHs table and includes the Provider name from the Mc_Provd table and the Site name from the Mc_Site table. The view is as follows:

SELECT mc_pcphs.*, mc_provd.lnm, mc_provd.fnm, mc_provd.mi, mc_provd.prov_title, mc_site.nm 
FROM mc_pcphs 
LEFT OUTER JOIN mc_provd ON mc_pcphs.prv_num = mc_provd.prv_num 
LEFT OUTER JOIN mc_site ON mc_pcphs.site_num = mc_site.site_num 
WHERE Mc_pcphs.mem_num = ?Parm_Mem_Num   
AND Mc_pcphs.active_ind = .T. 
ORDER BY Mc_pcphs.eff_thru DESC, Mc_pcphs.eff_from DESC

On SQL Server, I see the INSERT INTO Mc_PcpHs statement, and no others. Just like I want. However, the TableUpdate() returns .F. and I get error 1547.

What am I missing? I will be happy to provide any additional info you'd like.

TIA,