>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?
I believe the answer I gave you still remains the same. You can do it through updatable views. I started to read on views when I saw your first question, but I think this is the direction you should be heading.
If it's not broken, fix it until it is.
My Blog