lnConHandle = oMySqlData.db_connect("rlp_spotlight") SET MULTILOCKS ON =SQLEXEC(lnConHandle,"SELECT * FROM prodattrib WHERE uniq_key = ?Uniq_key","zcrsProdAttrib") aa=CURSORSETPROP("Buffering",3,"zcrsProdAttrib") ----> aa = .T. TEXT TO updNameList NOSHOW UNIQ_KEY zcrsProdAttrib.UNIQ_KEY, PART_NO zcrsProdAttrib.PART_NO, ...... && etc. more fields ENDTEXT TEXT TO updFldList NOSHOW UNIQ_KEY, PART_NO, ...... && etc. more fields ENDTEXT bb=CURSORSETPROP("Tables", 'rlp_spotlight.prodattrib', 'zcrsProdAttrib') ----> bb = .T. bb=CURSORSETPROP("UpdateNameList", updNameList, 'zcrsProdAttrib') ----> bb = .T. bb=CURSORSETPROP("UpdatableFieldList", updFldList, 'zcrsProdAttrib') ----> bb = .T. bb=CURSORSETPROP("SendUpdates", .t., 'zcrsProdAttrib') ----> bb = .T.In the form's cmdSave button I have the following code
SELECT zcrsProdAttrib IF NOT TABLEUPDATE() =AERROR(abcd) =MESSAGEBOX(abcd[2]) ENDIFThe error message from abcd is