Hi,
I'm still learning Progress and am trying to run an output from our Syteline database. Here is my query that I have:
OUTPUT TO l:\test\testfolder\runrate.dat.
EXPORT DELIMITER ","
"Item"
"Description"
"Machine Run Rate"
"Labor Run Rate"
.
FOR EACH ITEM WHERE product-code = "FGCTL1",
FIRST job where ITEM.ITEM = job.ITEM,
EACH jrt-sch WHERE job.job = jrt-sch.job AND jrt-sch.oper-num = 10,
EACH jobroute WHERE job.job = jobroute.job AND jobroute.wc = "855" NO-LOCK:
EXPORT DELIMITER ","
item.item
ITEM.DESCRIPTION
jrt-sch.pcs-per.mch-hr
jrt-sch.pcs-per-lbr-hr
.
END.
What I'm trying to do is get a job for each item from that product code. I need to get the job to connect into the jrt-sch table (job route schedule). Then I want to pull each jrt-sch associated with that job that has a 10 for oper-num. Finally i need only those jrt-sch that are from 855 in the jobroute table.
How can i tier this down to the results I want?
Thanks
I'm still learning Progress and am trying to run an output from our Syteline database. Here is my query that I have:
OUTPUT TO l:\test\testfolder\runrate.dat.
EXPORT DELIMITER ","
"Item"
"Description"
"Machine Run Rate"
"Labor Run Rate"
.
FOR EACH ITEM WHERE product-code = "FGCTL1",
FIRST job where ITEM.ITEM = job.ITEM,
EACH jrt-sch WHERE job.job = jrt-sch.job AND jrt-sch.oper-num = 10,
EACH jobroute WHERE job.job = jobroute.job AND jobroute.wc = "855" NO-LOCK:
EXPORT DELIMITER ","
item.item
ITEM.DESCRIPTION
jrt-sch.pcs-per.mch-hr
jrt-sch.pcs-per-lbr-hr
.
END.
What I'm trying to do is get a job for each item from that product code. I need to get the job to connect into the jrt-sch table (job route schedule). Then I want to pull each jrt-sch associated with that job that has a 10 for oper-num. Finally i need only those jrt-sch that are from 855 in the jobroute table.
How can i tier this down to the results I want?
Thanks