Sorting rows in a cluster

Wed, 20 Oct 2004 20:03:00 +0100

This is a multi-part message in MIME format.

------=_NextPart_000_005C_01C4B6DF.CD08BA40
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

My final word on this topic ( I promise ).

I am suggesting that the current reference file be mapped in a second file
statement, but this time as the primary with the orderby syntax as below, 

File orig-refnce alias new-primry primary occurs 15

Access orderby column using .via. request.etc.

File orig-prmry alias new-seconry secondary

Access via .using columns of new-primry etc.

File orig-refnce reference

Access etc.

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 19:13
To: Whittall, Conrad; powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster

That sounds like a winner. I will give it a try. Thanks!

Cheers ... Harvey

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Whittall, Conrad
Sent: Wednesday, October 20, 2004 10:28 AM
To: powerh-l@lists.sowder.com
Subject: RE: Sorting rows in a cluster

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.

I have used this technique quite a few times with great success.

Best regards,
Conrad 

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. 

RDB allows updateable views only if one table is involved. 

Cheers ... Harvey

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

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

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 

       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. 

------=_NextPart_000_005C_01C4B6DF.CD08BA40
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:ns1=3D"http://www.exclaimer.co.uk">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[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
 namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"country-region"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"address"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"City"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"Arial Black";
	panose-1:2 11 10 4 2 1 2 2 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Courier New";}
p
	{mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal;
	font-family:Arial;
	color:navy;}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>
<O:SMARTTAGTYPE name=3D"place" =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></O:SMARTTAGT=
YPE><O:SMARTTAGTYPE name=3D"City" =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"></O:SMARTTAGT=
YPE>
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>My final word on this topic ( I =
promise ).<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I am suggesting that the current =
reference
file be mapped in a second file statement, but this time as the primary =
with
the orderby syntax as below, <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>File orig-refnce
alias new-primry primary occurs 15<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Access orderby
column using &#8230;via&#8230; =
request&#8230;etc&#8230;<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p>=
</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>File orig-prmry
alias new-seconry secondary<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Access via
&#8230;using columns of new-primry =
etc&#8230;<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p>=
</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>File orig-refnce
reference<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dnavy
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;color:navy'>Access =
etc&#8230;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'><o:p></o:p></span></font></p>

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.<o:p></o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Harvey Orom<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 20 October 2004 =
19:13<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Whittall, Conrad;
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

That sounds like a winner. I will =
give it
a try. Thanks!<o:p></o:p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>Cheers ... <st1:City =
w:st=3D"on"><st1:place
 w:st=3D"on">Harvey</st1:place></st1:City></span></font><o:p></o:p></p>

</div>

<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b>
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Whittall, Conrad<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October =
20, 2004
10:28 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><o:p></o:p></p>

<div>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>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.</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>I have used this technique quite a few times with =
great
success.</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>Best regards,<br>
</span></font><b><i><font size=3D6 color=3Dnavy><span =
style=3D'font-size:24.0pt;
color:navy;font-weight:bold;font-style:italic'>Conrad</span></font></i></=
b><font
size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;font-family:Verdana'> =
<o:p></o:p></span></font></p>

<p><font size=3D1 color=3Dgray face=3DVerdana><span =
style=3D'font-size:7.5pt;
font-family:Verdana;color:gray'>Conrad Whittall</span></font><br>
<font size=3D1 color=3Dgray face=3DVerdana><span =
style=3D'font-size:7.5pt;font-family:
Verdana;color:gray'>Senior Solutions Architect, Global Customer =
Services,
Cognos Incorporated</span></font><br>
<st1:place w:st=3D"on"><font size=3D1 color=3Dgray face=3DVerdana><span
 style=3D'font-size:7.5pt;font-family:Verdana;color:gray'>3755 Riverside =
Drive, <st1:City
 w:st=3D"on">Ottawa</st1:City>, <st1:State =
w:st=3D"on">Ontario</st1:State>, <st1:PostalCode
 w:st=3D"on">K1G 4K9</st1:PostalCode>, <st1:country-region =
w:st=3D"on">Canada</st1:country-region></span></font></st1:place><o:p></o=
:p></p>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabIndex=3D-1>

</span></font></div>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><b><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</spa=
n></font></b><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Harvey Orom<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday 20 =
October 2004
11:46<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Rohde, Dirk<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><o:p></o:p></p>

<div>

True, but since I want to update =
the
primary file within the cluster, I think I will lose the =
convenience&nbsp; 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. =
<o:p></o:p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

RDB allows updateable views only if =
one
table is involved. <o:p></o:p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>Cheers ... <st1:City =
w:st=3D"on"><st1:place
 w:st=3D"on">Harvey</st1:place></st1:City></span></font><o:p></o:p></p>

</div>

<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Rohde, Dirk
[mailto:Dirk.Rohde@vpgroup.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October =
20, 2004
8:28 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Harvey Orom'<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><o:p></o:p></p>

<div>

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.<o:p></o:p>

</div>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Harvey Orom
[mailto:harvey@oromconsulting.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October =
20, 2004
8:13 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Joe Boyle<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><o:p></o:p></p>

<div>

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&nbsp;am not sure if&nbsp;that will do =
me much
good.<o:p></o:p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>Cheers ... <st1:City =
w:st=3D"on"><st1:place
 w:st=3D"on">Harvey</st1:place></st1:City></span></font><o:p></o:p></p>

</div>

<p><font size=3D3 color=3Dnavy face=3D"Arial Black"><span =
style=3D'font-size:12.0pt;
font-family:"Arial Black";color:navy'>Harvey Orom</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Orom
Consulting Ltd.</span></font> <br>
<st1:Street w:st=3D"on"><st1:address w:st=3D"on"><font size=3D2 =
face=3DArial><span
  style=3D'font-size:10.0pt;font-family:Arial'>2765 Tudor =
Ave.</span></font></st1:address></st1:Street>
<br>
<st1:place w:st=3D"on"><st1:City w:st=3D"on"><font size=3D2 =
face=3DArial><span
  =
style=3D'font-size:10.0pt;font-family:Arial'>Victoria</span></font></st1:=
City><font
 size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>, <st1:State
 w:st=3D"on">BC</st1:State></span></font> <br>
<st1:country-region w:st=3D"on"><font size=3D2 face=3DArial><span =
style=3D'font-size:
  =
10.0pt;font-family:Arial'>Canada</span></font></st1:country-region></st1:=
place><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>, V8N 1L6</span></font>
<br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Phone:
(250) 477-8332</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Email:
harvey@oromconsulting.com</span></font> <br>
<font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>www.oromconsulting.com</span=
></font>
<o:p></o:p></p>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Joe Boyle
[mailto:joeboyle_adt@hotmail.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, October =
20, 2004
7:27 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Harvey Orom'<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>At the risk of stating the obvious, =
you
can only use cursors with relational databases.&nbsp; =
<O:P></O:P></span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><O:P></O:P>Which file system are =
you using
and which PH version and platform =
?<O:P></O:P></span></font><o:p></o:p></p>

<div>

<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'><O:P></O:P>Regards, Joe.</span></font><o:p></o:p></p>

<O:P></O:P>

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.<O:P></O:P><o:p></o:p>

</div>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabIndex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Harvey Orom<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 20 October 2004 =
00:06<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Bickel, Jon<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><O:P></O:P><o:p></o:p></p>

</div>

<div>

<O:P></O:P>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&nbsp; loop to put a designer file. I am =
just
trolling for a more&nbsp;elegant solution. Someone suggested a cursor - =
what do
you think of that?<O:P></O:P><o:p></o:p>

</div>

<p><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:blue'>Cheers ... <ST1:CITY u1:st=3D"on"><ST1:PLACE =
u1:st=3D"on"><st1:City
w:st=3D"on"><st1:place =
w:st=3D"on">Harvey</ST1:PLACE></ST1:CITY></st1:place></st1:City></span></=
font><O:P></O:P><o:p></o:p></p>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> =
powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]<b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Bickel, Jon<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Tuesday, October =
19, 2004
3:21 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: Sorting rows =
in a
cluster</span></font><O:P></O:P><o:p></o:p></p>

<div>

<p class=3DMsoNormal><ST1:CITY u1:st=3D"on"><ST1:PLACE =
u1:st=3D"on"><st1:City w:st=3D"on"><st1:place
 w:st=3D"on"><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;
  =
font-family:Arial;color:blue'>Harvey</span></font></st1:place></st1:City>=
</ST1:PLACE></ST1:CITY><font
size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:blue'>,</span></font><O:P></O:P><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'><O:P></O:P>Is it possible =
to&nbsp;get the
reference file first and then retrieve the primary, or is =
the&nbsp;retrieval of
the reference file based on a value from the =
primary?</span></font><O:P></O:P><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'><O:P></O:P>jb</span></font><O:P></O:=
P><o:p></o:p></p>

</div>

<blockquote =
style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Harvey Orom
[mailto:harvey@oromconsulting.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Tuesday, October =
19, 2004
5:01 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Sorting rows in =
a cluster</span></font><O:P></O:P><o:p></o:p></p>

<div>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Is there any way to present the rows =
in&nbsp;a&nbsp;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&nbsp;from a =
reference
file.) The primary file is being updated in this =
screen.</span></font><O:P></O:P><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><O:P></O:P>Thanks in =
advance...</span></font><O:P></O:P><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 color=3Dnavy face=3D"Arial =
Black"><span
style=3D'font-size:12.0pt;font-family:"Arial =
Black";color:navy'><O:P></O:P>Harvey
Orom</span></font> <O:P></O:P><o:p></o:p></p>

</div>

</blockquote>

</blockquote>

</blockquote>

</blockquote>

</blockquote>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><O:P></O:P>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</sp=
an></font><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>This message
may contain privileged and/or confidential information.&nbsp; 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.&nbsp; Thank you.</span></font> <o:p></o:p></p>

</div>

</blockquote>

</div>

</body>

</html>

------=_NextPart_000_005C_01C4B6DF.CD08BA40--