Hi,
I am new to Progress and trying to create a progress code for the following SQL analogy:
select
pp_acct_rep,
counts = count(*)
from
tt_mismatches
group by
pp_acct_rep
order by
pp_acct_rep
Here is what I am trying to code, but every time I get a wrong result :
for each tt_mismatches break by pp_acct_rep:
accumulate pp_acct_rep (sub-count)
end.
display
pp_acct_rep (accum sub-count pp_acct_rep) skip.
Apparently I am missing something ? Any help please.
I am new to Progress and trying to create a progress code for the following SQL analogy:
select
pp_acct_rep,
counts = count(*)
from
tt_mismatches
group by
pp_acct_rep
order by
pp_acct_rep
Here is what I am trying to code, but every time I get a wrong result :
for each tt_mismatches break by pp_acct_rep:
accumulate pp_acct_rep (sub-count)
end.
display
pp_acct_rep (accum sub-count pp_acct_rep) skip.
Apparently I am missing something ? Any help please.