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,
Bill Armbrecht
VFP MCP