Sorting in QUICK?

[Michael Lee]

If this is a relational database (which I don't think it is) you could create a
cursor from both files and with an ORDER BY. If it isn't you are SOL
(Sorta-Outa-Luck).

Michael Lee
MCL Systems Inc.


Charles Lewis wrote:

> What I am trying to do may not be possible. Consider the following access
> statements:
>
> file dorm-data primary occurs 16
>      access sequential
> select if date-in > 0 and date-out = 0
> file name-index reference occurs with dorm-data
>      access viaindex student-idnum using student-idnum of dorm-data
>
> This will correctly display all current dorm students. However I would like
> to order this display sorted by NAME of NAME-INDEX (an index) or maybe even
> by GENDER of NAME-INDEX (not an index) by NAME of NAME-INDEX. Is there a way
> to do this in quick? If not, I may run a quiz report to disk, and pop the
> user into an editor...
>
> chas
>
> ====================================
> Charles Lewis
> Director of Administrative Computer Services
> Southwestern Adventist University
> PO Box 567
> Keene, TX 76059
>
> Phone: (817) 645-3921 #220
> Fax: (817) 556-4744
> Email: lewisc@swau.edu
> ====================================
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.