>see DBSETPROP in help
>
>CREATE SQL VIEW "LVBATCHHEADER" ;
> AS SELECT * FROM amvets!batchheader ;
> WHERE Batchheader.batchno = lvBatchTrans.batchno ;
> ORDER BY Batchheader.batchno
>
>DBSetProp('LVBATCHHEADER', 'View', 'UpdateType', 1)
>DBSetProp('LVBATCHHEADER', 'View', 'WhereType', 1)
>DBSetProp('LVBATCHHEADER', 'View', 'FetchMemo', .T.)
>DBSetProp('LVBATCHHEADER', 'View', 'SendUpdates', .T.)
>DBSetProp('LVBATCHHEADER', 'View', 'UseMemoSize', 255)
>DBSetProp('LVBATCHHEADER', 'View', 'FetchSize', 100)
>DBSetProp('LVBATCHHEADER', 'View', 'MaxRecords', -1)
>DBSetProp('LVBATCHHEADER', 'View', 'Tables', 'amvets!batchheader')
>DBSetProp('LVBATCHHEADER', 'View', 'Prepared', .F.)
>DBSetProp('LVBATCHHEADER', 'View', 'CompareMemo', .T.)
>DBSetProp('LVBATCHHEADER', 'View', 'FetchAsNeeded', .F.)
>DBSetProp('LVBATCHHEADER', 'View', 'FetchSize', 100)
>DBSetProp('LVBATCHHEADER', 'View', 'Comment', "")
>DBSetProp('LVBATCHHEADER', 'View', 'BatchUpdateCount', 1)
>DBSetProp('LVBATCHHEADER', 'View', 'ShareConnection', .F.)
>
>*!* Field Level Properties for LVBATCHHEADER
>* Props for the LVBATCHHEADER.batchno field.
>DBSetProp('LVBATCHHEADER.batchno', 'Field', 'KeyField', .T.)
>DBSetProp('LVBATCHHEADER.batchno', 'Field', 'Updatable', .T.)
>DBSetProp('LVBATCHHEADER.batchno', 'Field', 'UpdateName', 'amvets!batchheader.batchno')
>DBSetProp('LVBATCHHEADER.batchno', 'Field', 'DataType', "C(10)")
>* Props for the LVBATCHHEADER.gl_year field.

Hi Ross,

Thanks for your help! I finally understood, the WhereType is, in View Designer, "SQL WHERE clause..." section, by clicking on 'Key fields only',
the problem went away!