Accessing data from a referenced file twice over

[Joshua Camacho]

Hello, I'm trying to get a hold of a field that is "two files away":

File CUSTOMER is what I need the "Salesman Name" to be returned on.

File CUSTOMERX, which has the same key as CUSTOMER, has a Salesman ID on attribute 4.

File SALESMAN has the salesman's name on attribute 1.

How do I get the salesman's name to be able to appear on a SORT of CUSTOMER?

SORT CUSTOMER SALESMAN.NAME

This does NOT work:

==========

File DICT CUSTOMER Record SALESMAN.NAME

001 A

002 0

003 SLSM.NAME

004

005

006

007 TCUSTOMERX;x;;4]TSALESMAN;x;;1

008

009 L

010 20

[Daniel Klein]

Works on the latest jBASE 5.8 release.

What is the error message?

Danny

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAAEHHzjg4k2PYan9OavgstsXPf15WBnyBjRL1w8Dx1Y04UKxhg%40mail.gmail.com.

[Joshua Camacho]

No error. I was putting the code in Attr7, and Becky told me to place it in Attr8. Problem solved, thank you.

To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CADNxFdMTTYpwXYJCoZ4gEJir1%3Ddk6uCob0beWOJAg0SxU9TnLQ%40mail.gmail.com.

[Daniel Klein]

I did try it in both 7 and 8 and it works in either.

To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAAEHHzhkkOYz%3DgNsGS7JFUQTX%2BfqctSZ82-7cMNwBhHhNndkqw%40mail.gmail.com.