>CURSORSETPROP("UpdateNameList",; > "fldCodigoEmpleado tbNomina.fldCodigoEmpleado,; > fldNumeroCta tbNomina.fldNumeroCta,; > fldMonto tbNomina.fldMonto,; > fldTipoRegistro tbNomina.fldTipoRegistro,; > fldNombreEmp tbNomina.fldNombreEmp",; > cNombreCursor) >CURSORSETPROP("WhereType",3,cNombreCursor) >>
>>SQLExec(lnHandle,'select * from dbo.authors','v_authors') >>CursorSetProp('KeyFieldList','au_id','v_authors') >>CursorSetProp('WhereType',1,'v_authors') >>CursorSetProp('Tables','authors','v_authors') >> >>CursorSetProp("UpdateNameList", ; >> "au_id authors.au_id,"+; >> "au_lname authors.au_lname,"+; >> "au_fname authors.au_fname,"+; >> "contract authors.contract",'V_authors') >> >>CursorSetProp('UpdatableFieldList','au_fname,au_lname,contract','v_authors') >>CursorSetProp('SendUpdates',.T.,'v_authors') >>CursorSetProp('Buffering',5,'v_authors') >>In updatenamelist fields appear in pairs, on the left is your fieldname and on the right basetable's fieldname. ie:
>>SQLExec(lnHandle,'select FirstName as Fname, LastName as Lname'+; >>' from ServerTable...', 'v_myview) >> >>CursorSetProp("UpdateNameList", ; >> "Fname ServerTable.FirstName,"+; >> "Lname ServerTable.LastName",'V_myView') >>Cetin