Timestamp is a reserved word (didn't find it at first, I have A97 here), so change the UpdateName to:

DBSetProp('VUEHV_MASTER.timestamp', 'Field', 'UpdateName', 'tblhv_master."timestamp"')

and it should work OK. HTH

>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)")
>