Hi,
Why do you make things so complex and hard to understand even to read.
Things like :
/* query example */
DEFINE QUERY myQuery FOR EACH customer WHERE cust-num > 100 NO-LOCK.
OPEN QUERY myQuery.
GET FIRST myQuery.
IF AVAILABLE customer THEN
DISPLAY customer.cust-name.
DO WHILE NOT QUERY-OFF_END(myQuery) :
GET NEXT myQuery.
DISPLAY
END.
/* more comple query example */
DEFINE QUERY myQuery FOR EACH customer WHERE cust-num > 100, EACH order OF customer WHERE order.delivery-date > TODAY ORDER-BY order.delivery-date.
/* simple table and straightforward reading */
FOR EACH customer WHERE cust-num > 50:
DISPLAY customer.cust-name.
END.
/* more complex table reading */
FOR EACH customer WHERE cust-num > 50, EACH order OF customer WHERE order.status > 100 :
DISPLAY customer.cust-name order.
FOR EACH orderline OF order, FIRST item OF orderline :
DISPLAY oderline.item-number item.description.
END.
END.
This is much easier to read and understand, don't you think.
Why make things so unreadable. Hope i will be heard.
Regards.

complexity
Bob Y
I still wait for feedback on my remarks ;)
regards
Peter Giffin
briartoys
Christiawan
Raul Serrano
My code examples are taken (more or less) from our current application framework, that is Progress v9.
Which has made everything easy to design database oriented software design.
I still wonder why there is no such elements in .Net for eg.
Regards