>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,

Are your update criteria fields and Send SQL updates marked?

Oscar