How do I use the date range in Progress 4gl

Question

I’m doing a program to list

• list customer
• Number of applications
• Order quantity per customer

all for the month of February 2015

as I would do to catch only the interval of

>= 01/02/2015 && <=  28/02/2015 

Answer 1

I saw what you did there in the commentary. But using functions that need the value of the table you are searching for automatically transforms for each into a full table scan, that is, it will not be able to apply indices to your query. In banks with a large number of orders, this practice throws its performance in the trash. I’d do it that way:

FOR EACH ped-venda WHERE ped-venda.dt-emissao >= 02/01/2015 
     AND ped-venda.dt-emissao <= 02/28/2015 
 BREAK BY ped-venda.nome-abrev BY ped-venda.dt-emissao DESC:

Being the fixed date, as Voce suggested. This makes Progress use the most appropriate Intel, greatly accelerating the search for the result set of your query.