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