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