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.