Qdesign - Sorting Question

[David Morrison - Corporate]

Eric,

This is a cool technique!  

I would think that you'd want to make the record length equal to the maximum
screen width (for our environment, it's 132 characters).

Do you ever break up the SORTFILE records into individual fields rather than
leaving them as one big field?  It's more work, but I can see breaking them
up in order to handle editing like BWZ and FLOAT "$".

Thanks.

p.s. for Catherine:  We use SET REPORT DEVICE VIEWER in one QUICK program
that calls a QUIZ program, but avoid using that technique because it takes
about 5 seconds to load QUIZ interactively.

David Morrison
McBride Electric



-----Original Message-----
From: Hoppe, Eric EP [mailto:Eric.Hoppe@steelscape-inc.com]
Sent: Wednesday, October 30, 2002 12:38 PM
To: 'catherine.litten@valleypres.org'; Powerhouse List Server
Subject: RE: Qdesign - Sorting Question


Catherine-

We often use an auxiliary file set up specifically for the purpose of
displaying data in the sort order requested by the user.

We have a record called SORTFILE, it has a single element (unique ascending
key) called KY-SORTFILE of 100 characters.
In the quick screen, the SORTFILE is populated with whatever values we want
to manipulate how the data will be retrieved by quick.
We then do a while retrieving on the SORTFILE linking it to whatever
reference tables we want and the screen populates perfectly.

For instance, if the data is held as:
AAA	123
BBB	034
CCC	567
And the user wants to sort by numbers instead of letters, we will populate
KY-SORTFILE as:
123AAA
034BBB
567CCC
Doing a 'while ret' on SORTFILE will return the data sorted by the numbers.
You can then link the letters to whatever other file to return the
supporting reference information.

Was that clear enough?  We use this method often, so it is second nature to
me and I may not be explaining it well enough.  If you like, I could send
you some code snippets to explain further.

We are running Powerhouse 7.10.G on OpenVMS 7.1 on an Alpha.

Good luck!
---ehops
Eric Hoppe
Steelscape, Inc.
Senior Systems Analyst
Washington State, USA
360.673.8247

-----Original Message-----
From: Catherine Litten [mailto:catherine.litten@valleypres.org] 
Sent: Wednesday, October 30, 2002 10:42 AM
To: Powerhouse List Server
Subject: Qdesign - Sorting Question


I am rather stagnant in my use of QDesign - I usually develop simple screens
with little more than redefines of data and data population based on user
responses.  However, this time I have a user that wants a screen that is
really much like a report.  This is just a find screen that lists who is on
suspension (usually less than a screen full)  They would like this in alpha
order by last name and name is not a key field.  

Any recommendations on how to show the data sorted the way they like
(usually I just tell them they need a quiz report instead of a screen)
without changing the structure of the database?

Thank you,
Catherine



*****************************
Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital 
 15107 Vanowen Street, Van Nuys, CA 91405  (818)782.6600 x 2140 
catherine.litten@valleypres.org
********************************
The thoughts, comments, and opinions expressed herein are mine.  They do not
reflect those of my employer, nor anyone else.
********************************
This E-mail is covered by the Electronic Communications Privacy Act, 18
U.S.C. §§ 2510-2521 and is legally privileged. This information is
confidential information and is intended only for the use of the individual
or entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this transmission in error, please notify the sender immediately by return
electronic transmission and then immediately delete this transmission.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________
Scanned for viruses on 30 Oct 2002 13:12:56
No viruses found.
Virus scanning by http://erado.com