I have started updating the core table and that works, however here is the eview code:

***************** Begin View Definition LV_EMPLOYEE_U ***************

CREATE SQL VIEW "LV_EMPLOYEE_U" ;
AS SELECT Employee.e_id, Employee.e_cto FROM employee!employee

DBSetProp('LV_EMPLOYEE_U', 'View', 'UpdateType', 1)
DBSetProp('LV_EMPLOYEE_U', 'View', 'WhereType', 3)
DBSetProp('LV_EMPLOYEE_U', 'View', 'FetchMemo', .T.)
DBSetProp('LV_EMPLOYEE_U', 'View', 'SendUpdates', .T.)
DBSetProp('LV_EMPLOYEE_U', 'View', 'UseMemoSize', 255)
DBSetProp('LV_EMPLOYEE_U', 'View', 'FetchSize', 100)
DBSetProp('LV_EMPLOYEE_U', 'View', 'MaxRecords', -1)
DBSetProp('LV_EMPLOYEE_U', 'View', 'Tables', 'employee!employee')
DBSetProp('LV_EMPLOYEE_U', 'View', 'Prepared', .F.)
DBSetProp('LV_EMPLOYEE_U', 'View', 'CompareMemo', .T.)
DBSetProp('LV_EMPLOYEE_U', 'View', 'FetchAsNeeded', .T.)
DBSetProp('LV_EMPLOYEE_U', 'View', 'FetchSize', 100)
DBSetProp('LV_EMPLOYEE_U', 'View', 'Comment', "")
DBSetProp('LV_EMPLOYEE_U', 'View', 'BatchUpdateCount', 1)
DBSetProp('LV_EMPLOYEE_U', 'View', 'ShareConnection', .F.)

*!* Field Level Properties for LV_EMPLOYEE_U
* Props for the LV_EMPLOYEE_U.e_id field.
DBSetProp('LV_EMPLOYEE_U.e_id', 'Field', 'KeyField', .T.)
DBSetProp('LV_EMPLOYEE_U.e_id', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE_U.e_id', 'Field', 'UpdateName', 'employee!employee.e_id')
DBSetProp('LV_EMPLOYEE_U.e_id', 'Field', 'DataType', "I")
* Props for the LV_EMPLOYEE_U.e_cto field.
DBSetProp('LV_EMPLOYEE_U.e_cto', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE_U.e_cto', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE_U.e_cto', 'Field', 'UpdateName', 'employee!employee.e_cto')
DBSetProp('LV_EMPLOYEE_U.e_cto', 'Field', 'DataType', "N(8,2)")


by the way, thanks for your help.

Nick Patel