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

  • Thread starter Thread starter James Palmer
  • Start date Start date
Status
Not open for further replies.
J

James Palmer

Guest
Out of interest, I added a JoinDate and a Months field to sports2000 in 64bit Progress 11.7.3. I populated the data as follows: FOR EACH customer EXCLUSIVE-LOCK: customer.months = RANDOM(1,2). customer.joindate = ADD-INTERVAL(TODAY,RANDOM(0,48) * 1,"MONTHS"). END. The query below functions fine in shared memory connections and client/server. So it either works fine in 11.7.3 or there is more to the story. DEF VAR p AS INT EXTENT 2 INIT[10,20]. FOR EACH Customer WHERE Customer.JoinDate + p[customer.Months] <= TODAY no-lock: MESSAGE Customer.Name. END.

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