... CURSORSETPROP("UpdateNameList","tel_code posseder_tel.Tel_Code,"+; "ver_code posseder_tel.ver_code,"+; "pos_etat posseder_tel.pos_etat","telcursor") CURSORSETPROP("KeyFieldList","tel_code,ver_code") CURSORSETPROP("UpdatableFieldList","Tel_code,ver_code,pos_etat","telcursor") ...>this message appears 'invalid update column name "tel_code" on CURSORSETPROP("KeyFieldList","tel_code,ver_code")
> >LcSQL="SELECT posseder_tel.tel_code,posseder_tel.pos_etat,posseder_tel.ver_code FROM "+; > "posseder_tel posseder_tel "+; > " INNER JOIN telephone telephone "+; > "ON posseder_tel.tel_code = telephone.tel_code "+; > " INNER JOIN version Version "+; > "ON posseder_tel.ver_code = version.ver_code" > >SQLEXEC(gnConnHandle,LcSQL,'telcursor') > >CURSORSETPROP("Tables","posseder_tel") >CURSORSETPROP("KeyFieldList","tel_code,ver_code") >CURSORSETPROP("UpdatableFieldList","Tel_code,ver_code,pos_etat","telcursor") >CURSORSETPROP("UpdateNameList","Tel_code posseder_tel.Tel_Code,"+; > "ver_code posseder_tel.ver_code,"+; > "pos_etat posseder_tel.pos_etat","telcursor") >CURSORSETPROP("SendUpdates",.T.,"telcursor") >CURSORSETPROP("WhereType",3,"telcursor") >CURSORSETPROP("BatchUpdateCount",5,"telcursor") >CURSORSETPROP("Buffering",5,"telcursor") >>