Recently, I have created a thread about a situation I had where I needed to update the SQL result. Basically, the goal was to include some empty fields in the SQL command and scan thru the dataset after and update accordingly. With a VFP backend, I can do this. But, when I test that against a SQL Server backend, I get this message:
"Column ... is read only"
Basically, I do something like this:
SELECT Customer.Name,'' AS Place FROM Customer
Then, I scan this dataset and would like to do this:
loRow("Place")="Something"
How can I make my column writable?