Hi Bill,
I'm getting the same error writing to an Oracle table. I'm going to change the SQL Where clause from Key fields only to Key and updatable or key and modified.
If that doesn't work, I am going to ask the Oracle dba to define a view in oracle of the tables and create a VFP remote view of the Oracle View. Since I'm only writing to one Oracle table in the oracle view, the update should work.
I'll let you know how things worked out.
Have you put a trace on the ODBC driver and looked at the SQL statements that are being sent to SQL Server?
Good luck.
Paul
>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,