[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: FIND xxx OF yyy rules

  • Thread starter Thread starter Patrice Perrot
  • Start date Start date
Status
Not open for further replies.
P

Patrice Perrot

Guest
It is not a rule, the good rules are well known... you can use COMPILE XREF as a workaround. Example : Orderline_of_item.p find first orderline of item no-lock no-error . COMPILE Orderline_of_item.p XREF xref-Orderline_of_item.p In Xref-Orderline_of_item.p , you have the "ACCESS" lines. COMPILE C:\travail\progress\test_riverside\orderline_of_item.p CPINTERNAL utf-8 CPSTREAM 1252 STRING "OrderLine" 9 NONE UNTRANSLATABLE STRING "Item" 4 NONE UNTRANSLATABLE => ACCESS sports2000.OrderLine Itemnum => ACCESS sports2000.Item Itemnum SEARCH sports2000.OrderLine itemnum Xref show that you are using orderline.itemnum and item.itemnum when you are doing a "find first orderline of item no-lock no-error ." It seems that "find first orderline of item no-lock no-error ." is the same that "find first orderline where orderline.itemnum = item.itemnum no-lock no-error ." I use this workaround on more complex queries ...

Continue reading...
 
Status
Not open for further replies.
Back
Top