=CURSORSETPROP("UpdateNameList", ,,,)See 138094 and How to make SQL Pass-Through cursor updatable FAQ #8153 for working examples.
>PUBLIC gnconnhandle >STORE SQLCONNECT('TestingPatient', 'cm12345', 'mypassword') TO gnConnHandle >IF gnConnHandle <= 0 >= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error') >ELSE >= MESSAGEBOX('Connection made', 48, 'SQL Connect Message') > >SQLEXEC(gnconnhandle,"select req_det_id, test_name, autoser from labtest1 where req_det_id = 105695", "mycursor") > > >CURSORSETPROP("SendUpdates",.T., "mycursor") >cursorsetprop("BatchUpdateCount",1, "mycursor") >cursorsetprop("CompareMemo",.T., "mycursor") >cursorsetprop("FetchAsNeeded",.F., "mycursor") >cursorsetprop("FetchMemo",.T., "mycursor") >cursorsetprop("FetchSize",100, "mycursor") >cursorsetprop("MaxRecords",-1, "mycursor") >cursorsetprop("Prepared",.F., "mycursor") >CURSORSETPROP("KeyFieldList", "autoser","mycursor") >cursorsetprop("AllowSimultaneousFetch",.F., "mycursor") >cursorsetprop("UpdateType",1, "mycursor") >cursorsetprop("UseMemoSize",255, "mycursor") >cursorsetprop("Tables","labtest1", "mycursor") >cursorsetprop("UpdatableFieldList","req_det_id,test_name,autoser", "mycursor") >cursorsetprop("WhereType",3, "mycursor") > > >browse >* = SQLDISCONNECT(gnconnHandle) >ENDIF > >use>