General information
Category:
The Mere Mortals Framework
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only