Order by with select if in PHWeb

Wed, 28 May 2003 13:37:46 -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_01C3253F.DA0F77C0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I just happen to be doing quite a bit with the ORDERBY clause at the =
moment.

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.

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.

Best regards,
Conrad

Conrad Whittall
Solutions Architect, Global Customer Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, =
Canada

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

HI,

OpenVMS 7.3
Powerhouse 8.30z1
Powerhouse Web 2.30z1

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?

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/

=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

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_01C3253F.DA0F77C0
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>I just happen to be doing quite a bit with the =
ORDERBY clause at the moment.</FONT>
</P>

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.

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

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

<P><FONT SIZE=3D2>Conrad Whittall</FONT>
<BR><FONT SIZE=3D2>Solutions Architect, Global Customer Services</FONT>
<BR><FONT SIZE=3D2>Cognos Incorporated, 3755 Riverside Drive, Ottawa, =
Ontario, K1G 4K9, Canada</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:22</FONT>
<BR><FONT SIZE=3D2>To: Powerhouse List</FONT>
<BR><FONT SIZE=3D2>Subject: Order by with select if in PHWeb</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>HI,</FONT>
</P>

<P><FONT SIZE=3D2>OpenVMS 7.3</FONT>
<BR><FONT SIZE=3D2>Powerhouse 8.30z1</FONT>
<BR><FONT SIZE=3D2>Powerhouse Web 2.30z1</FONT>
</P>

<P><FONT SIZE=3D2>Is there a way to make an =ABorder by=BB on my =
primary file in PhWEB after I</FONT>
<BR><FONT SIZE=3D2>made a =BBselect if=BB on the same primary =
file?</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>

<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: &quot;subscribe&quot; in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: &quot;unsubscribe =
&lt;password&gt;&quot; in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>

<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_01C3253F.DA0F77C0--