Sorting on a Clustered Screen
Oran Shapitka
oran@intertechsystems.com
Mon, 29 May 2000 14:22:36 -0600
This is a multi-part message in MIME format.
------=_NextPart_000_000D_01BFC979.5649B4C0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit
Colin,
If you have are using Image, you will need the sort order field to be
defined in Image as a sorted key. If you are using KSAM, you will need to
have the sort order as a key structure and use the '@' or '@@' for partial
key retrieval in sorted order. If you are using a Allbase or Oracle, you
can retrieve the data by defining the sorted order.
If none of these are an option; call QTP to build a temporary subfile before
retrieving the data or calling the screen. Then use the subfile to display
the data on the screen. If you need to update the data, have the subfile
relate to the data file via a secondary file declaration in the screen.
Under HP3000, the QTP step is slow enough to be visible to the end user.
The same technique used under HP-UX is so fast, the end user does not
realize any type of non Quick processing.
Email or phone me if you want any further clarification to the above.
Oran Shapitka, ISP
Intertech Business Systems, Inc.
1564, 10303 Jasper Ave Email: oran@intertechsystems.com
Edmonton, AB T5J 3N6 Canada Voice: (780) 413-0400 Fax: (780)
413-0398
<http://www.intertechsystems.com/>
-----Original Message-----
From: owner-powerh-l@sphere.swau.edu
[mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Colin Glass
Sent: Monday, May 29, 2000 2:06 PM
To: powerh-l@lists.swau.edu
Subject: Sorting on a Clustered Screen
We are using PowerHouse version 8.19.C5 on HP3000.
My question is regarding Qdesign screens. We have a clustered screen and
our internal customers who use this screen have requested that the cluster
be sorted. Can this be done in the screen itself or is there another way?
_______________________________
Colin Glass - cglass@mlcc.mb.ca
Programmer/Analyst
Manitoba Liquor Control Commission
Ph: (204) 474-5597
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
------=_NextPart_000_000D_01BFC979.5649B4C0
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META content=3D"text/html; charset=3Dus-ascii" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2>Colin,</FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2>If you have are using =
Image, you will=20
need the sort order field to be defined in Image as a sorted key. =
If you=20
are using KSAM, you will need to have the sort order as a key structure =
and use=20
the '@' or '@@' for partial key retrieval in sorted order. If =
you are=20
using a Allbase or Oracle, you can retrieve the data by defining =
the sorted=20
order.</FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2>If none of these are an =
option; call=20
QTP to build a temporary subfile before retrieving the data or calling =
the=20
screen. Then use the subfile to display the data on the =
screen. If=20
you need to update the data, have the subfile relate to the data file =
via a=20
secondary file declaration in the screen. Under HP3000, the QTP =
step is=20
slow enough to be visible to the end user. The same technique used =
under=20
HP-UX is so fast, the end user does not realize any type of non Quick=20
processing.</FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2>Email or phone me if =
you want any=20
further clarification to the above.</FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2>
<P align=3Dleft><FONT face=3DArial size=3D2>Oran Shapitka, =
ISP</FONT></P>
<P align=3Dleft><B><FONT color=3D#000000 face=3D"Bell MT">Intertech =
Business Systems,=20
Inc.</FONT></B></P>
<P align=3Dleft><FONT color=3D#000000 face=3DArial size=3D1>1564, 10303 =
Jasper Ave =20
Email: oran@intertechsystems.com</FONT></P>
<P align=3Dleft><FONT color=3D#000000 face=3DArial size=3D1>Edmonton, =
AB T5J=20
3N6 Canada Voice: (780) 413-0400 =20
Fax: (780) 413-0398</FONT></P>
<P align=3Dleft><U><FONT color=3D#0000ff><<A=20
href=3D"http://www.intertechsystems.com/"=20
target=3D_blank>http://www.intertechsystems.com/</A>></FONT></U></P><B=
R><BR></DIV></FONT>
<P><FONT size=3D2>-----Original Message-----<BR>From:=20
owner-powerh-l@sphere.swau.edu<BR>[</FONT><A=20
href=3D"mailto:owner-powerh-l@sphere.swau.edu"><FONT=20
size=3D2>mailto:owner-powerh-l@sphere.swau.edu</FONT></A><FONT =
size=3D2>]On Behalf=20
Of Colin Glass<BR>Sent: Monday, May 29, 2000 2:06 PM<BR>To:=20
powerh-l@lists.swau.edu<BR>Subject: Sorting on a Clustered =
Screen<BR><BR><BR>We=20
are using PowerHouse version 8.19.C5 on HP3000.<BR><BR>My question is =
regarding=20
Qdesign screens. We have a clustered screen and<BR>our internal =
customers=20
who use this screen have requested that the cluster<BR>be sorted. =
Can this=20
be done in the screen itself or is there another=20
way?<BR><BR>_______________________________<BR>Colin Glass -=20
cglass@mlcc.mb.ca<BR>Programmer/Analyst<BR>Manitoba Liquor Control=20
Commission<BR>Ph: (204) 474-5597<BR>=3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D<BR>Subscribe: "subscribe powerh-l" in=20
message body to majordomo@lists.swau.edu<BR>Unsubscribe: "unsubscribe =
powerh-l"=20
in message to majordomo@lists.swau.edu<BR>This list is closed, thus to =
post to=20
the list, you must be a subscriber.<BR></FONT></P></BODY></HTML>
------=_NextPart_000_000D_01BFC979.5649B4C0--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.