General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only