[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: EXTENT argument is a field in a DB query. Terminates from session

  • Thread starter Thread starter Mike Fechner
  • Start date Start date
Status
Not open for further replies.
M

Mike Fechner

Guest
You may have hit a version specific bug. As James said, the queries are bad. When the extent field is of size 2, you should actually be using this FOR EACH FOR EACH Customer WHERE Customer.Months = 1 and Customer.JoinDate < TODAY - 10 or Customer.Months = 2 and Customer.JoinDate < TODAY - 20 no-lock: MESSAGE Customer.CustName. END. And ensure there's an index on Months and JoinDate in that order.

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