Mixed-direction key not working? - Found problem, corrected

Started by James Zukowski, July 28, 2021, 05:33:52 PM

Previous topic - Next topic

James Zukowski

I've got a file with a secondary key of:
PO_Date/d + PO_Num + Cust + ShipTo + Seq

I can read directly through the file with no problems. But if I want to grab the first entry in a group and skip the rest of the Seq values, I issue:
read (F,key=PO_Date$:PO_Num$:Cust$:ShipTo$:$FF$)

It always goes to the end of file at this point. The file is created properly, with the first field descending and the remaining ascending. Am I missing something?

Thanks, all!
James Zukowski
Sr. Developer - J&E

BRAND>SAFWAY
Brand Industrial Services

Mike King

Have you tried including the kno= option in the READ to make sure the system is using the correct key?

Mike King
President - BBSysco Consulting - http://www.bbsysco.com
eMail: mike.king@bbsysco.com

James Zukowski

I already found the problem and corrected it. Thanks.
James Zukowski
Sr. Developer - J&E

BRAND>SAFWAY
Brand Industrial Services