Order by with select if in PHWeb

Wed, 28 May 2003 13:59:55 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C32542.F1D7D930
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Since you're using RMS there are only two options that I can think of =
to
easily achieve what you're looking for (others please feel free to jump =
in
if you can think of anything else).

The first way is, as described earlier, to add the physical index to =
your
RMS file and add the definition of that index to your PowerHouse =
dictionary.

The second, which might be viable if the volume of data selected isn't =
too
great, is to copy the selected data to a permanent indexed =
subfile...created
with the required structure and index(es) using QUIZ or QTP. Once you =
have
copied the data to the subfile (WHILE RETRIEVING etc., and perhaps =
tagged it
with some unique "session" identifier so that you can delete it again =
when
the user is done), you could take the user to another screen/page where =
the
indexed subfile is accessed as the primary...after passing that session =
id
so that the correct data is retrieved.

Best regards,
Conrad

-----Original Message-----
From: Etienne Rompr=E9 [mailto:rompre@kangouroute.com]
Sent: 28 May 2003 13:43
To: Whittall, Conrad
Cc: Powerhouse List
Subject: Re: Order by with select if in PHWeb

Hi Conrad,

Thanks for the info.  My problem is that the field I want to sort on is =
not
a key in the dictionary.  Is there a turnaround possible other than to
change the dictionary???

Thanks!

--=20
Etienne Rompr=E9
Directeur Marketing - Technologies
Marketing - Technologies Director

Kangouroute Inc.=20
Location autos - camions
Car & Truck Rental
Qu=E9bec Canada

t=E9l: (418) 266-9500
fax: (418) 683-2610
courriel/email: rompre@kangouroute.com
internet:  http://www.kangouroute.com/

>=20
> I just happen to be doing quite a bit with the ORDERBY clause at the
moment.
>=20
> The ORDERBY clause of the ACCESS statement is only valid if the =
record you
> are accessing is a table in a relational database. You don't say =
whether
you
> are using RMS files or an RDBMS.
>=20
> To emulate an ORDERBY using RMS you will have to build an index in =
the
order
> that you require and force PowerHouse to specifically use that index =
with
> the VIAINDEX clause.
>=20
> Best regards,
> Conrad
>=20
> Conrad Whittall
> Solutions Architect, Global Customer Services
> Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9,
Canada
>=20
> -----Original Message-----
> From: Etienne Rompr=E9 [mailto:rompre@kangouroute.com]
> Sent: 28 May 2003 13:22
> To: Powerhouse List
> Subject: Order by with select if in PHWeb
>=20
>=20
> HI,
>=20
> OpenVMS 7.3
> Powerhouse 8.30z1
> Powerhouse Web 2.30z1
>=20
> Is there a way to make an =ABorder by=BB on my primary file in PhWEB =
after I
> made a =BBselect if=BB on the same primary file?
>=20
> Thanks!
>=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.

------_=_NextPart_001_01C32542.F1D7D930
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: Order by with select if in PHWeb</TITLE>
</HEAD>
<BODY>
<BR>

<P><FONT SIZE=3D2>Since you're using RMS there are only two options =
that I can think of to easily achieve what you're looking for (others =
please feel free to jump in if you can think of anything =
else).</FONT></P>

<P><FONT SIZE=3D2>The first way is, as described earlier, to add the =
physical index to your RMS file and add the definition of that index to =
your PowerHouse dictionary.</FONT></P>

The second, which might be viable if the volume of =
data selected isn't too great, is to copy the selected data to a =
permanent indexed subfile...created with the required structure and =
index(es) using QUIZ or QTP. Once you have copied the data to the =
subfile (WHILE RETRIEVING etc., and perhaps tagged it with some unique =
&quot;session&quot; identifier so that you can delete it again when the =
user is done), you could take the user to another screen/page where the =
indexed subfile is accessed as the primary...after passing that session =
id so that the correct data is retrieved.

<P><FONT SIZE=3D2>Best regards,</FONT>
<BR><FONT SIZE=3D2>Conrad</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Etienne Rompr=E9 [<A =
HREF=3D"mailto:rompre@kangouroute.com">mailto:rompre@kangouroute.com</A>=
]</FONT>
<BR><FONT SIZE=3D2>Sent: 28 May 2003 13:43</FONT>
<BR><FONT SIZE=3D2>To: Whittall, Conrad</FONT>
<BR><FONT SIZE=3D2>Cc: Powerhouse List</FONT>
<BR><FONT SIZE=3D2>Subject: Re: Order by with select if in PHWeb</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi Conrad,</FONT>
</P>

<P><FONT SIZE=3D2>Thanks for the info.&nbsp; My problem is that the =
field I want to sort on is not</FONT>
<BR><FONT SIZE=3D2>a key in the dictionary.&nbsp; Is there a turnaround =
possible other than to</FONT>
<BR><FONT SIZE=3D2>change the dictionary???</FONT>
</P>

<P><FONT SIZE=3D2>Thanks!</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Etienne Rompr=E9</FONT>
<BR><FONT SIZE=3D2>Directeur Marketing - Technologies</FONT>
<BR><FONT SIZE=3D2>Marketing - Technologies Director</FONT>
</P>

Kangouroute Inc. 
 Location autos - camions
 Car &amp; Truck Rental
 Qu=E9bec Canada

<P><FONT SIZE=3D2>t=E9l: (418) 266-9500</FONT>
<BR><FONT SIZE=3D2>fax: (418) 683-2610</FONT>
<BR><FONT SIZE=3D2>courriel/email: rompre@kangouroute.com</FONT>
<BR><FONT SIZE=3D2>internet:&nbsp; <A =
HREF=3D"http://www.kangouroute.com/" =
TARGET=3D"_blank">http://www.kangouroute.com/</A></FONT>
</P>
<BR>
<BR>

&gt; 
 &gt; I just happen to be doing quite a bit with the =
ORDERBY clause at the moment.
 &gt; 
 &gt; The ORDERBY clause of the ACCESS statement is =
only valid if the record you
 &gt; are accessing is a table in a relational =
database. You don't say whether you
 &gt; are using RMS files or an RDBMS.
 &gt; 
 &gt; To emulate an ORDERBY using RMS you will have =
to build an index in the order
 &gt; that you require and force PowerHouse to =
specifically use that index with
 &gt; the VIAINDEX clause.
 &gt; 
 &gt; Best regards,
 &gt; Conrad
 &gt; 
 &gt; Conrad Whittall
 &gt; Solutions Architect, Global Customer =
Services
 &gt; Cognos Incorporated, 3755 Riverside Drive, =
Ottawa, Ontario, K1G 4K9, Canada
 &gt; 
 &gt; -----Original Message-----
 &gt; From: Etienne Rompr=E9 [<A =
HREF=3D"mailto:rompre@kangouroute.com">mailto:rompre@kangouroute.com</A>=
]
 &gt; Sent: 28 May 2003 13:22
 &gt; To: Powerhouse List
 &gt; Subject: Order by with select if in =
PHWeb
 &gt; 
 &gt; 
 &gt; HI,
 &gt; 
 &gt; OpenVMS 7.3
 &gt; Powerhouse 8.30z1
 &gt; Powerhouse Web 2.30z1
 &gt; 
 &gt; Is there a way to make an =ABorder by=BB on my =
primary file in PhWEB after I
 &gt; made a =BBselect if=BB on the same primary =
file?
 &gt; 
 &gt; Thanks!
 &gt;

<P><FONT SIZE=3D2>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.</FONT></P>

</BODY>
</HTML>
------_=_NextPart_001_01C32542.F1D7D930--