Progress V 8.3B
Database 13.4 Gb
I'm trying to get information for later import into a report. I need to find all part numbers (db.ro_det.ro_routing) that begin with "57", the tooling code for this part (db.ro_det.ro_tooling) and the length for the part located in an array of a comment field (db.cmt_det.cmt_cmmt[2]). I'm having trouble getting the value from the comment field.
This bit of code gets me the Item number and tooling code:
============================================
OUTPUT TO clad.txt.
FOR EACH db.ro_det WHERE db.ro_det.ro_routing BEGINS "57":
DISPLAY db.ro_det.ro_routing db.ro_det.ro_tool.
END.
What I need yet is the length stored in a comment array (2) for each ro_routing.
db.cmt_det.cmt_cmmt[2] (comment field)
Thanks in advance,
Troy
Database 13.4 Gb
I'm trying to get information for later import into a report. I need to find all part numbers (db.ro_det.ro_routing) that begin with "57", the tooling code for this part (db.ro_det.ro_tooling) and the length for the part located in an array of a comment field (db.cmt_det.cmt_cmmt[2]). I'm having trouble getting the value from the comment field.
This bit of code gets me the Item number and tooling code:
============================================
OUTPUT TO clad.txt.
FOR EACH db.ro_det WHERE db.ro_det.ro_routing BEGINS "57":
DISPLAY db.ro_det.ro_routing db.ro_det.ro_tool.
END.
What I need yet is the length stored in a comment array (2) for each ro_routing.
db.cmt_det.cmt_cmmt[2] (comment field)
Thanks in advance,
Troy