Progress 10

C

CBH

New Member
hi there,

i'm new to progress.... Is there any ebook that i can refer on writing query?
i'm familiar with SQL but one it come to Progress is totally zero.
Or prehaps did any one know how to convert the below SQL to Progress?
SELECT DISTINCT part, MAX(Qty) FROM PART
 
Here you can find the documentation:

http://communities.progress.com/pcom/docs/DOC-103525

You might have a look into the ABL Essentials in the ABL section to get a better understanding.

In a nutshell:

The Progress 4GL has a completely different approach than SQL. Where SQL is dataset oriented the 4GL is record oriented. That means that you can "translate" SQL queries into 4GL code but they will behave different when it comes to record locking and transaction handling.

HTH, RealHeavyDude.
 
In ABL, the typical approach for that query would be to define a temp-table with part and qty and do a for each on part, lookup each part no in the TT, create the record if it doesn't exist, then make the qty the max of the qty already there and the one in the current record. Which said, I think we are missing something since why is there going to be more than one record per part in part?
 
You must log in or register to reply here.
Back
Top