Different table field values

[Barcode]

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

 

[Barcode]

Hey,

I found a solution. It's not pretty but it works. I would like to thank everyone for the many other times your articles have helped.

********************************
OUTPUT TO clad.txt.

FOR EACH db.ro_det WHERE db.ro_det.ro_routing BEGINS "57":

FIND FIRST cmt_det no-lock
WHERE cmt_indx = ro_cmtindx no-error.

DISPLAY db.ro_det.ro_routing db.ro_det.ro_tool db.cmt_det.cmt_cmmt[2]
WHEN AVAILABLE cmt_det.
END.
********************************

Thanks again,

Troy