Sorting rows in a cluster
Harvey Orom
harvey@oromconsulting.com
Tue, 19 Oct 2004 16:05:55 -0700
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C4B5F5.84074360
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Unfortunately, I get the reference file from the primary file. I know I
could use a view, with temp fields in the cluster, and a loop to put a
designer file. I am just trolling for a more elegant solution. Someone
suggested a cursor - what do you think of that?
Cheers ... Harvey
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Bickel, Jon
Sent: Tuesday, October 19, 2004 3:21 PM
To: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
Harvey,
Is it possible to get the reference file first and then retrieve the
primary, or is the retrieval of the reference file based on a value from the
primary?
jb
-----Original Message-----
From: Harvey Orom [mailto:harvey@oromconsulting.com]
Sent: Tuesday, October 19, 2004 5:01 PM
To: powerh-l@lists.sowder.com
Subject: Sorting rows in a cluster
Is there any way to present the rows in a cluster in a PowerHouse Quick
screen in a sequence by a column that is not in the primary file (I.e., the
column I want to sort by comes from a reference file.) The primary file is
being updated in this screen.
Thanks in advance...
Harvey Orom
------=_NextPart_000_0010_01C4B5F5.84074360
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D372064822-19102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Unfortunately, I get the reference file from the primary file. =
I know I=20
could use a view, with temp fields in the cluster, and a loop to =
put a=20
designer file. I am just trolling for a more elegant solution. =
Someone=20
suggested a cursor - what do you think of that?</FONT></SPAN></DIV>
<P><SPAN class=3D372064822-19102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Cheers=20
... Harvey</FONT></SPAN></P>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Bickel, Jon<BR><B>Sent:</B> Tuesday, October 19, 2004 =
3:21=20
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: =
Sorting rows=20
in a cluster<BR><BR></FONT></DIV>
<DIV><SPAN class=3D230173222-19102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Harvey,</FONT></SPAN></DIV>
<DIV><SPAN class=3D230173222-19102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D230173222-19102004><FONT face=3DArial =
color=3D#0000ff size=3D2>Is=20
it possible to get the reference file first and then retrieve the =
primary, or is the retrieval of the reference file based on a =
value from=20
the primary?</FONT></SPAN></DIV>
<DIV><SPAN class=3D230173222-19102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D230173222-19102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>jb</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Harvey Orom=20
[mailto:harvey@oromconsulting.com]<BR><B>Sent:</B> Tuesday, October =
19, 2004=20
5:01 PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> =
Sorting=20
rows in a cluster<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D067405021-19102004>Is =
there any way=20
to present the rows in a cluster in a PowerHouse Quick =
screen in a=20
sequence by a column that is not in the primary file (I.e., the =
column I=20
want to sort by comes from a reference file.) The primary file =
is being=20
updated in this screen.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D067405021-19102004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D067405021-19102004>Thanks in=20
advance...</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D067405021-19102004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D067405021-19102004></SPAN></FONT><FONT face=3D"Arial Black"=20
color=3D#000080>Harvey Orom</FONT> <BR></DIV>
<DIV> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0010_01C4B5F5.84074360--