Take a look at mskb #Q138094 How to Create Updatable Views by Using SQL Passthrough> and faq #8153 How to make SQL Pass-Through cursor updatable.

>Hi Sergey,
>
>Thanks, It works!
>
>I have this sql command and wanted to make the cursor updateable. I don't know what's wrong but it does no work.
>
>csql = [Select *, Space(30) as desc2, .F. as Highlight from payroll!position order by desc]
>nResult = Sqlexec(thisform.lnconn, csql, "curPosition")
>
>Select curPosition
>*!* Index On position Tag position
>*!* Index On desc2 Tag desc2
>
>Cursorsetprop("Tables","position","curPosition")
>Cursorsetprop("KeyFieldList","position","curPosition")
>
>Cursorsetprop("UpdateNameList",;
> "position position.position, "+;
> "Desc position.desc, "+;
> "Desig position.desig","curposition")
>
>Cursorsetprop("UpdatableFieldList","desc, Desig","curPosition")
>Cursorsetprop("SendUpdates",.T.,"curPosition")
>Cursorsetprop("Buffering",5,"curPosition")
>
>I do this because I want to be able to update directly on Grid Control. Whenever I edit a record and save it, I just put the command =Tableupdate(1,.T.) but whenever I looked at the base table, it does not update itself.