Kbase P19639: How to preform a query looking for records past a specific d
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2003 |
|
Status: Unverified
NEGATEDGOAL:
3. How do I get records that are newer than 01/01/2002? [I tried the following without success in FRAME orderline [sacust8.r]]
for each order-line where ORDER-LINE.part-no begins (get-value("partnum")) no-lock ,each order of order-line where order.order-date > 01/01/2001 no-lock,customer of order no-lock
by order.
GOAL:
How to preform a query looking for records past a specific date.
FIX:
Using the where clause of a find or FOR EACH statement will accomplish this.
Syntax Example;
FOR EACH invoice WHERE invoice.invdate is > today: