Sorting rows in a cluster

Wed, 20 Oct 2004 08:12:33 -0700

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C4B67C.8D2C7F00
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.

Cheers ... Harvey
Harvey Orom
Orom Consulting Ltd.
2765 Tudor Ave.
Victoria, BC
Canada, V8N 1L6
Phone: (250) 477-8332
Email: harvey@oromconsulting.com
www.oromconsulting.com

  -----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

  At the risk of stating the obvious, you can only use cursors with
relational databases.

  Which file system are you using and which PH version and platform ?

  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.

----------------------------------------------------------------------------
--

  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

  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_0000_01C4B67C.8D2C7F00
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word" xmlns:st1 =3D=20
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3DUS-ASCII">
<META content=3D"MSHTML 6.00.2900.2523" 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 name=3D"place"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><o:SmartTagType=20
name=3D"City"=20
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></o:SmartTagT=
ype><!--[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><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 idea=20
is academic, given my environment. I can create cursors in Rdb, but =
I&nbsp;am=20
not sure if&nbsp;that will do me much good.</FONT></SPAN></DIV>
<DIV><SPAN class=3D116030215-20102004><FONT face=3DArial color=3D#0000ff =

size=3D2>&nbsp;</DIV>
<DIV>Cheers=20
... Harvey</DIV>
Harvey Orom =
 <FONT=20
face=3DArial size=3D2>Orom Consulting Ltd. 2765=20
Tudor Ave. Victoria, BC =
 <FONT=20
face=3DArial size=3D2>Canada, V8N 1L6 Phone:=20
(250) 477-8332 Email:=20
harvey@oromconsulting.com www.oromconsulting.com 
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
 <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: Joe Boyle=20
 [mailto:joeboyle_adt@hotmail.com] Sent: Wednesday, October =
20, 2004=20
 7:27 AM To: 'Harvey Orom' Cc:=20
 powerh-l@lists.sowder.com Subject: RE: Sorting rows in a=20
 cluster </DIV>
 <DIV class=3DSection1>
 <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 =
databases.&nbsp;=20
 <o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Which file =
system are=20
 you using and which PH version and platform =
?<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p>
 <DIV>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,=20
 Joe.<SPAN=20
 style=3D"COLOR: navy"><o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">This e-mail =
and all=20
 information contained in it is confidential and may be legally =
privileged. If=20
 you are not the intended<SPAN=20
 style=3D"COLOR: navy"> <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, =
distribution,=20
 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=20
  promptly by e-mail that you have done so. The content of this e-mail =
and any=20
  attachments sent with it may have been altered without the consent or=20
  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 2004=20
  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=20
  style=3D"FONT-SIZE: 12pt"><o:p>&nbsp;</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 get=20
  the reference file from the primary file. I know I could use a view, =
with temp=20
  fields in the cluster, and a&nbsp; loop to put a designer file. I am =
just=20
  trolling for a more&nbsp;elegant solution. Someone suggested a cursor =
- what=20
  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 ... =
<st1:City=20
  w:st=3D"on"><st1:place=20
  w:st=3D"on">Harvey</st1:place></st1:City></SPAN></FONT><o:p></o:p></P>
  <BLOCKQUOTE 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, =
Jon<BR><B><SPAN=20
    style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 19, =
2004 3:21=20
    PM<BR><B><SPAN 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 face=3DArial=20
    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">&nbsp;<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&nbsp;get the reference file first and then retrieve the primary, =
or is=20
    the&nbsp;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">&nbsp;<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=20
      class=3DMsoNormal style=3D"MARGIN-BOTTOM: 12pt"><FONT =
face=3DTahoma 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> Harvey=20
      Orom [mailto:harvey@oromconsulting.com]<BR><B><SPAN=20
      style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 19, =
2004 5:01=20
      PM<BR><B><SPAN 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> 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 =
present=20
      the rows in&nbsp;a&nbsp;cluster in a PowerHouse Quick screen in a =
sequence=20
      by a column that is not in the primary file (I.e., the column I =
want to=20
      sort by comes&nbsp;from a reference file.) The primary file is =
being=20
      updated in this screen.</SPAN></FONT><o:p></o:p></P></DIV>
      <DIV>
      <P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN =

      style=3D"FONT-SIZE: =
12pt">&nbsp;<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 =

      style=3D"FONT-SIZE: =
12pt">&nbsp;<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 =

      style=3D"FONT-SIZE: =
12pt">&nbsp;<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BLOCKQUOTE>=
</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0000_01C4B67C.8D2C7F00--