>When I was using the VFPOleDB data provider to access VFP data from my application, from VB.NET, I was able to update a data row. So, assuming I was having a SQL like this:
>
>
>SELECT MyTable.Numero,0 AS Enabled FROM MyTable
>
>
>I was then able to do this:
>
>
>toRow("Enabled") = 1
>
>
>where toRow is a data row of one record from the SQL result.
>
>However, with the SQLClient data provider, I obtain a message that says:
>
>"Column 'Enabled' is read only."
>
>How can I workaround that?
Did you look into creating an updatable view in SQL Server 2005 and using it instead of the base table?
If it's not broken, fix it until it is.
My Blog