Setting lActive to the Key Field did not really seem to help....

>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