Posted by Grant Foraker on April 30, 2012 at 13:02:49:
In Reply to: FILE(LUN) REVERSE posted by Carl Haaser on April 30, 2012 at 09:14:12:
As I read your post, your secondary key is just the Buyer #. The keys (PO #'s) returned via KEY or PREV will not be in numeric order.
Solution is to define your secondary keys as multi-field. I don't like the Comet implementation. But here goes.
Add space to the end of your data record to make room for the secondary keys and to keep them together. Say you expanded the PO record from 350 to 500. Then add various secondary keys you might want ...
@(400);QBUYER$;QPNBR$;_ ! SORT BY BUYER
@(410);QSTATE$;QPNBR$;_ ! SORT BY STATE
@(420);QVNBR$;QPNBR$;_ ! SORT BY VENDOR NUMBER
@(430);QVNAME$;QPNBR$;_ ! SORT BY VENDOR NAME
I left some gaps ...
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.