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?