Sorting Items on a Screen

[Nancy Tietz]

I'm sorry, I didn't read your whole message... the Suprtool solution is
great for displaying records, but you want to update.  Perhaps you can try
linking back from the sorted file to the manual master.  
Another idea is to sort your records at night so that when the user uses the
find procedure, the records come up in sorted order because the dataset is
sorted in that order.  This is often not feasible and even messy when the
dataset is a manual, because you can't delete them and add them back in with
details attached.  
nt

-----Original Message-----
From: Nancy Tietz [mailto:ntietz@mcare3.med.umich.edu]
Sent: Thursday, October 12, 2000 11:31 AM
To: 'Carol Kaffenberger'; powerh-l@lists.swau.edu
Subject: RE: Sorting Items on a Screen


I've used a Suprtool routine to extract and sort the data, then call the
screen that is to display the information with the sorted file as the
primary file (defined as an MPE file in the PDL).  This works great for
small sets of data.


Nancy J. Tietz
Business Analyst
M-Care IS

Email:  ntietz@umich.edu
Phone: (734) 332-2359




-----Original Message-----
From: Carol Kaffenberger [mailto:kaffenbe@karmanos.org]
Sent: Thursday, October 12, 2000 11:20 AM
To: powerh-l@lists.swau.edu
Subject: Sorting Items on a Screen


We have a screen that sequentially retrieves & displays
records from an Image manual master dataset.
The user selects an entry from the values on this screen and
other programs are called to do the actual work.  There are
more than 30 items on this screen.   We would like the items
to be displayed in ascending order by the index of this
dataset (ID CODE - See below).  I tried to add a sort key to
the dataset via Architect, but sort keys are only valid for
detail datasets.  I tried various ACCESS statements with no
luck.

This is what it looks like now:

               Generic Table Maintenance           10:53
EP8070KS

ID CODE   TABLE NAME                   ID CODE   TABLE NAME
01 TRIC     Tri-County Area City          02 SPAN    Spanish
Surname List
03 SDIR     Street Direction                   04 SIGR
Site Group & Desc
05 OLDS    ICD-I to ICD-II                  06 CTRL    Last#
Comp Assigned

This is what I would like it to look like:

               Generic Table Maintenance           10:53
EP8070KS

ID CODE   TABLE NAME                   ID CODE   TABLE NAME
01 CTRL    Last# Comp Assigned        02 OLDS     ICD-I to
ICD-II
03 SDIR     Street Direction                   04 SIGR
Site Group & Desc
05 SPAN    Spanish Surname List          06 TRIC
Tri-County Area City

Any help would be greatly appreciated.

PH 8.19.C5, MPE/ix 5.5
--
Carol Kaffenberger
Karmanos Cancer Institute
Detroit, Michigan


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
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
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
This list is closed, thus to post to the list, you must be a subscriber.