Sorting rows in a cluster
Whittall, Conrad
Conrad.Whittall@Cognos.COM
Wed, 20 Oct 2004 13:28:23 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4B6C9.FD4AC050
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
You could use a database view as a non-updateable Primary, and then
retrieve the underlying row from the 'real' table as a Secondary (access
via the primary key included in the view) and allow the user to interact
with the fields from the secondary records...so retaining the default
PowerHouse processing and eliminating the need for procedural loops,
etc.
=20
I have used this technique quite a few times with great success.
=20
Best regards,
Conrad=20
Conrad Whittall
Senior Solutions Architect, Global Customer Services, Cognos
Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada
________________________________
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Harvey Orom
Sent: Wednesday 20 October 2004 11:46
To: Rohde, Dirk
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
True, but since I want to update the primary file within the cluster, I
think I will lose the convenience and elegance of standard PowerHouse
procedures. I would need to use temp fields in the cluster, and create a
loop to write the file as a designer file.=20
=20
RDB allows updateable views only if one table is involved.=20
=20
Cheers ... Harvey
=20
-----Original Message-----
From: Rohde, Dirk [mailto:Dirk.Rohde@vpgroup.com]
Sent: Wednesday, October 20, 2004 8:28 AM
To: 'Harvey Orom'
Subject: RE: Sorting rows in a cluster
=09
=09
Does RDB not allow you to define a view? If you define a view
linking your primary and reference files, you should then be able to
access it as your primary and sort on the reference field.
-----Original Message-----
From: Harvey Orom [mailto:harvey@oromconsulting.com]
Sent: Wednesday, October 20, 2004 8:13 AM
To: Joe Boyle
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
=09
=09
My environment is vms, rdb, and PowerHouse 7.10.G1. That
release of PowerHouse doesn't appear to recognize any of the cursor
keywords, so maybe the cursor idea is academic, given my environment. I
can create cursors in Rdb, but I am not sure if that will do me much
good.
=20
Cheers ... Harvey
Harvey Orom=20
Orom Consulting Ltd.=20
2765 Tudor Ave.=20
Victoria, BC=20
Canada, V8N 1L6=20
Phone: (250) 477-8332=20
Email: harvey@oromconsulting.com=20
www.oromconsulting.com=20
-----Original Message-----
From: Joe Boyle
[mailto:joeboyle_adt@hotmail.com]
Sent: Wednesday, October 20, 2004 7:27 AM
To: 'Harvey Orom'
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
=09
=09
At the risk of stating the obvious, you can only
use cursors with relational databases. =20
=20
Which file system are you using and which PH
version and platform ?
=20
Regards, Joe.
This e-mail and all information contained in it
is confidential and may be legally privileged. If you are not the
intended recipient, your access to this e-mail is unauthorized. Any use,
dissemination, distribution, publication or copying by you of this
e-mail or any of the information contained within it is prohibited and
may be unlawful. Do not open any attachments, delete it immediately from
your system and notify the sender promptly by e-mail that you have done
so. The content of this e-mail and any attachments sent with it may have
been altered without the consent or knowledge of the author.
=09
________________________________
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Harvey Orom
Sent: 20 October 2004 00:06
To: Bickel, Jon
Cc: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster
=20
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,
=20
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?
=20
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.
=20
Thanks in advance...
=20
Harvey Orom=20
=20
This message may contain privileged and/or confidential =
information. If you have received this e-mail in error or are not the =
intended recipient, you may not use, copy, disseminate or distribute it; =
do not open any attachments, delete it immediately from your system and =
notify the sender promptly by e-mail that you have done so. Thank you.=20
=20
------_=_NextPart_001_01C4B6C9.FD4AC050
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16">
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"=20
name=3D"place"></o:SmartTagType><o:SmartTagType=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"=20
name=3D"City"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Arial Black;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: =
"Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD><BODY lang=3DEN-US vLink=3Dpurple link=3Dblue><DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004>You could use a database view as a =
non-updateable=20
Primary, and then retrieve the underlying row from the 'real' table as a =
Secondary (access via the primary key included in the view) and allow =
the user=20
to interact with the fields from the secondary records...so retaining =
the=20
default PowerHouse processing and eliminating the need for procedural =
loops,=20
etc.</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004></SPAN></FONT> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004>I have used this technique quite a few times =
with great=20
success.</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004></SPAN></FONT> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana size=3D2><SPAN=20
class=3D596432217-20102004></SPAN></FONT><SPAN lang=3Den-us><FONT =
face=3DVerdana=20
size=3D2><SPAN lang=3Den-us><FONT face=3DVerdana size=3D2>Best=20
regards,</FONT></SPAN><BR><SPAN lang=3Den-us><B><I><FONT face=3D"Times =
New Roman"=20
color=3D#000080 size=3D6>Conrad</FONT></I></B></SPAN> </DIV>
<P><SPAN lang=3Den-us><FONT face=3DVerdana color=3D#808080 =
size=3D1>Conrad=20
Whittall</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DVerdana =
color=3D#808080=20
size=3D1>Senior Solutions Architect, Global Customer Services, Cognos=20
Incorporated</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DVerdana =
color=3D#808080=20
size=3D1>3755 Riverside Drive, Ottawa, Ontario, K1G 4K9,=20
Canada</FONT></SPAN></P></FONT></SPAN>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> =
powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com] <B>On Behalf Of </B>Harvey=20
Orom<BR><B>Sent:</B> Wednesday 20 October 2004 11:46<BR><B>To:</B> =
Rohde,=20
Dirk<BR><B>Cc:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: =
Sorting rows=20
in a cluster<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=3D636283615-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>True,=20
but since I want to update the primary file within the cluster, I think =
I will=20
lose the convenience and elegance of standard PowerHouse =
procedures. I=20
would need to use temp fields in the cluster, </FONT></SPAN><SPAN=20
class=3D636283615-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>and create a loop=20
to write the file as a designer file. </FONT></SPAN></DIV>
<DIV><SPAN class=3D636283615-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D636283615-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>RDB=20
allows updateable views only if one table is involved. =
</FONT></SPAN></DIV>
<DIV><SPAN class=3D636283615-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D636283615-20102004><FONT face=3DArial color=3D#0000ff =
size=3D2>Cheers=20
... Harvey</FONT></SPAN></DIV>
<P><FONT face=3DArial size=3D2></FONT> </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> Rohde, Dirk=20
[mailto:Dirk.Rohde@vpgroup.com]<BR><B>Sent:</B> Wednesday, October 20, =
2004=20
8:28 AM<BR><B>To:</B> 'Harvey Orom'<BR><B>Subject:</B> RE: Sorting =
rows in a=20
cluster<BR><BR></FONT></DIV>
<DIV><SPAN class=3D410112915-20102004><FONT face=3DArial =
color=3D#0000ff size=3D2>Does=20
RDB not allow you to define a view? If you define a view linking your =
primary=20
and reference files, you should then be able to access it as your =
primary and=20
sort on the reference field.</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> Wednesday, =
October 20,=20
2004 8:13 AM<BR><B>To:</B> Joe Boyle<BR><B>Cc:</B>=20
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Sorting rows in a=20
cluster<BR><BR></FONT></DIV>
<DIV><SPAN class=3D116030215-20102004><FONT face=3DArial =
color=3D#0000ff size=3D2>My=20
environment is vms, rdb, and PowerHouse 7.10.G1. That release of =
PowerHouse=20
doesn't appear to recognize any of the cursor keywords, so maybe the =
cursor=20
idea is academic, given my environment. I can create cursors in Rdb, =
but=20
I am not sure if that will do me much =
good.</FONT></SPAN></DIV>
<DIV><SPAN class=3D116030215-20102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D116030215-20102004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Cheers ... Harvey</FONT></SPAN></DIV>
<P><FONT face=3D"Arial Black" color=3D#000080>Harvey Orom</FONT> =
<BR><FONT=20
face=3DArial size=3D2>Orom Consulting Ltd.</FONT> <BR><FONT =
face=3DArial=20
size=3D2>2765 Tudor Ave.</FONT> <BR><FONT face=3DArial =
size=3D2>Victoria,=20
BC</FONT> <BR><FONT face=3DArial size=3D2>Canada, V8N 1L6</FONT> =
<BR><FONT=20
face=3DArial size=3D2>Phone: (250) 477-8332</FONT> <BR><FONT =
face=3DArial=20
size=3D2>Email: harvey@oromconsulting.com</FONT> <BR><FONT =
face=3DArial=20
size=3D2>www.oromconsulting.com</FONT> </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> Joe Boyle=20
[mailto:joeboyle_adt@hotmail.com]<BR><B>Sent:</B> Wednesday, =
October 20,=20
2004 7:27 AM<BR><B>To:</B> 'Harvey Orom'<BR><B>Cc:</B>=20
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Sorting rows in a =
cluster<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">At the =
risk of=20
stating the obvious, you can only use cursors with relational=20
databases. <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Which =
file system=20
are you using and which PH version and platform=20
?<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Regards,=20
Joe.</SPAN></FONT><FONT color=3Dnavy><SPAN=20
style=3D"COLOR: navy"><o:p></o:p></SPAN></FONT></P>
<P><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">This =
e-mail and=20
all information contained in it is confidential and may be legally =
privileged. If you are not the intended</SPAN></FONT><FONT=20
color=3Dnavy><SPAN style=3D"COLOR: navy"> </SPAN></FONT><FONT =
face=3DArial=20
color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">recipient, your=20
access to this e-mail is unauthorized. Any use, dissemination,=20
distribution, publication or copying by you of this e-mail or any =
of the=20
information contained within it is prohibited and may be unlawful. =
Do not=20
open any attachments, delete it immediately from your system and =
notify=20
the sender promptly by e-mail that you have done so. The content =
of this=20
e-mail and any attachments sent with it may have been altered =
without the=20
consent or knowledge of the =
author.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><FONT=20
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D3>
</SPAN></FONT></DIV>
<P class=3DMsoNormal><B><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; =
FONT-FAMILY: Tahoma">=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]=20
<B><SPAN style=3D"FONT-WEIGHT: bold">On Behalf Of =
</SPAN></B>Harvey=20
Orom<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> 20 =
October=20
2004 00:06<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> =
Bickel,=20
Jon<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Cc:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting rows =
in a=20
cluster</SPAN></FONT><o:p></o:p></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN =
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Unfortunately, I=20
get the reference file from the primary file. I know I could use a =
view,=20
with temp fields in the cluster, and a loop to put a =
designer file.=20
I am just trolling for a more elegant solution. Someone =
suggested a=20
cursor - what do you think of =
that?</SPAN></FONT><o:p></o:p></P></DIV>
<P><FONT face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Cheers =
...=20
<st1:City w:st=3D"on"><st1:place=20
=
w:st=3D"on">Harvey</st1:place></st1:City></SPAN></FONT><o:p></o:p></P>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com]<B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Bickel,=20
Jon<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> =
Tuesday,=20
October 19, 2004 3:21 PM<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Sorting rows =
in a=20
cluster</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><st1:City w:st=3D"on"><st1:place =
w:st=3D"on"><FONT=20
face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">Harvey</SPAN></FONT></st1:place></st1:City><FONT=20
face=3DArial color=3Dblue size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">,</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Is it =
possible=20
to get the reference file first and then retrieve the =
primary, or=20
is the retrieval of the reference file based on a value =
from the=20
primary?</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial color=3Dblue =
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: =
Arial">jb</SPAN></FONT><o:p></o:p></P></DIV>
<BLOCKQUOTE=20
style=3D"MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: =
0cm">
<P class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: =
bold">From:</SPAN></B>=20
Harvey Orom [mailto:harvey@oromconsulting.com]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October =
19, 2004=20
5:01 PM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> =
powerh-l@lists.sowder.com<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> Sorting rows =
in a=20
cluster</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is there any way =
to=20
present the rows in a cluster in a PowerHouse Quick =
screen=20
in a sequence by a column that is not in the primary file =
(I.e., the=20
column I want to sort by comes from a reference file.) =
The=20
primary file is being updated in this=20
screen.</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks in=20
advance...</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Arial Black" color=3Dnavy =
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: 'Arial =
Black'">Harvey=20
Orom</SPAN></FONT> <o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" =
size=3D3><SPAN=20
style=3D"FONT-SIZE: =
12pt"> <o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BLOCKQUOTE>=
</DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV>
<P> <FONT FACE=3D"Arial" =
SIZE=3D"2">This message may contain privileged and/or confidential =
information. If you have received this e-mail in error or are not =
the intended recipient, you may not use, copy, disseminate or distribute =
it; do not open any attachments, delete it immediately from your system =
and notify the sender promptly by e-mail that you have done so. =
Thank you.</FONT>
</P>
</DIV></BODY></HTML>
------_=_NextPart_001_01C4B6C9.FD4AC050--