In the View Designer, lActive is the the only field that is marked updateable(as it should be) and it is marked as the Key Field, which is different from what you see below...... I will switch the view and see what happens....
>Where is the key field?
>
>Dan
>
>>here you go:
>>
>>LOCAL lcClientDBC
>>
>>lcClientDBC = This.cClientDBC
>>
>>CREATE SQL VIEW "lv_OfferDetailsByiBomId" ;
>> AS SELECT * ;
>> FROM &lcClientDBC + "!OfferDetail" ;
>> WHERE Offerdetail.iproductid = ?vp_iProductId;
>> AND Offerdetail.ibomid = ?vp_iBomId;
>> AND Offerdetail.lactive = .T.
>>
>>* Table-level Properties
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'SendUpdates', .T.)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'UpdateType', 1)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'WhereType', 3)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'FetchMemo', .T.)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'UseMemoSize', 255)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'FetchSize', 100)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'MaxRecords', -1)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'Tables', &lcClientDBC ;
>> + '!OfferDetail')
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'Prepared', .F.)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'CompareMemo', .T.)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'FetchAsNeeded', .F.)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'FetchSize', 100)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'Comment', ;
>> "Shows all active offer details for a particular iBomId")
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'BatchUpdateCount', 1)
>>DBSetProp('LV_OfferDetailsByiBomId', 'View', 'ShareConnection', .F.)
>>
>>* Field Level Properties
>>* Props for the LV_OfferDetailsByiBomId.lactive field.
>>DBSetProp('LV_OfferDetailsByiBomId.lactive', 'Field', 'KeyField', .F.)
>>DBSetProp('LV_OfferDetailsByiBomId.lactive', 'Field', 'Updatable', .T.)
>>DBSetProp('LV_OfferDetailsByiBomId.lactive', 'Field', 'UpdateName', ;
>> &lcClientDBC + '!OfferDetail.lactive')
>>DBSetProp('LV_OfferDetailsByiBomId.lactive', 'Field', 'Comment', ;
>> "Is this Offer active?")
>>DBSetProp('LV_OfferDetailsByiBomId.lactive', 'Field', 'DataType', "L")
>>
>>>This is sounding like a view problem. Can you post the view code?
>>>
>>>Dan