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.
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.