[progress Communities] [progress Openedge Abl] Forum Post: Re: Open Query Statement Problem

  • Thread starter Thread starter Steve Moore
  • Start date Start date
Status
Not open for further replies.
S

Steve Moore

Guest
This is a useful trick I found many years ago that seems to work: define temp-table ttNoOrder field field1 as char. create ttNoOrder. define query q1 for Customer, Order, ttNoOrder. open query q1 for each Customer no-lock, first Order of Customer outer-join no-lock, first ttNoOrder where not available(Order). get first q1. repeat while not query-off-end("q1"): display Customer.CustNum Customer.Name available(Order). get next q1. end.

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