Flores,

I have tried updating TIMESTAMP field in other tables also but problem is still there. As Nadya Nosonovsky said, it may be reserve word.

Anyway -

CREATE SQL VIEW "VUEHV_MASTER" ; 
   REMOTE CONNECT "cnnFB4U" ; 
   AS SELECT * FROM tblhv_master Tblhv_master ORDER BY Tblhv_master.v_no

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

*!* Field Level Properties for VUEHV_MASTER
* Props for the VUEHV_MASTER.v_no field.
DBSetProp('VUEHV_MASTER.v_no', 'Field', 'KeyField', .T.)
DBSetProp('VUEHV_MASTER.v_no', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.v_no', 'Field', 'UpdateName', 'tblhv_master.v_no')
DBSetProp('VUEHV_MASTER.v_no', 'Field', 'DataType', "C(8)")
* Props for the VUEHV_MASTER.v_date field.
DBSetProp('VUEHV_MASTER.v_date', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.v_date', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.v_date', 'Field', 'UpdateName', 'tblhv_master.v_date')
DBSetProp('VUEHV_MASTER.v_date', 'Field', 'DataType', "T")
* Props for the VUEHV_MASTER.v_type field.
DBSetProp('VUEHV_MASTER.v_type', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.v_type', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.v_type', 'Field', 'UpdateName', 'tblhv_master.v_type')
DBSetProp('VUEHV_MASTER.v_type', 'Field', 'DataType', "I")
* Props for the VUEHV_MASTER.payee_id field.
DBSetProp('VUEHV_MASTER.payee_id', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.payee_id', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.payee_id', 'Field', 'UpdateName', 'tblhv_master.payee_id')
DBSetProp('VUEHV_MASTER.payee_id', 'Field', 'DataType', "C(2)")
* Props for the VUEHV_MASTER.v_chqno field.
DBSetProp('VUEHV_MASTER.v_chqno', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.v_chqno', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.v_chqno', 'Field', 'UpdateName', 'tblhv_master.v_chqNo')
DBSetProp('VUEHV_MASTER.v_chqno', 'Field', 'DataType', "C(15)")
* Props for the VUEHV_MASTER.v_update field.
DBSetProp('VUEHV_MASTER.v_update', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.v_update', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.v_update', 'Field', 'UpdateName', 'tblhv_master.v_update')
DBSetProp('VUEHV_MASTER.v_update', 'Field', 'DataType', "I")
* Props for the VUEHV_MASTER.timestamp field.
DBSetProp('VUEHV_MASTER.timestamp', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.timestamp', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.timestamp', 'Field', 'UpdateName', 'tblhv_master.timestamp')
DBSetProp('VUEHV_MASTER.timestamp', 'Field', 'DataType', "T")
* Props for the VUEHV_MASTER.user_id field.
DBSetProp('VUEHV_MASTER.user_id', 'Field', 'KeyField', .F.)
DBSetProp('VUEHV_MASTER.user_id', 'Field', 'Updatable', .T.)
DBSetProp('VUEHV_MASTER.user_id', 'Field', 'UpdateName', 'tblhv_master.User_ID')
DBSetProp('VUEHV_MASTER.user_id', 'Field', 'DataType', "C(2)")