[stackoverflow] [progress Openedge Abl] Progress Query Needs To Be Convert In Sql Query

[Abhishek Singh]

Here is my code below :-

for each sku-subset no-lock
where sku-subset.wholesaler = ""
and sku-subset.subset-code = job-schedule.subset-code:

do c = 1 to num-entries(trim(sku-subset.check-type)):

find first tt-ssct
where tt-ssct.ct = entry(c,trim(sku-subset.check-type))
no-lock no-error.
if not available tt-ssct then do:
create tt-ssct.
assign tt-ssct.ct = entry(c,trim(sku-subset.check-type)).
end.
tt-ssct.sscnt = tt-ssct.sscnt + 1.

end.


end.

Thanks in advance. Please help me out.

Continue reading...