CURSORSETPROP("UpdateNameList",; "fldCodigoEmpleado tbNomina.fldCodigoEmpleado,; fldNumeroCta tbNomina.fldNumeroCta,; fldMonto tbNomina.fldMonto,; fldTipoRegistro tbNomina.fldTipoRegistro,; fldNombreEmp tbNomina.fldNombreEmp",; cNombreCursor) CURSORSETPROP("WhereType",3,cNombreCursor)Enmanuel
>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