Order by with select if in PHWeb

[Edis, Robert]

Etienne

Without a RDBMS to do the pre-processing for you and without the appropriate
index in the RMS you can only do a SORT in the PowerHouse code itself.
Alternately you could try using a 3rd party sort tool with temporary files.

Blue

-----Original Message-----
From: Etienne Rompré [mailto:rompre@kangouroute.com]
Sent: Wednesday, May 28, 2003 12:48 PM
To: Edis, Robert
Cc: Powerhouse List
Subject: Re: Order by with select if in PHWeb


HI Robert,

The code sample is :

FILE FKAFCES PRI

SELECT IF ECIE_NUME OF FKAFCES = NUME_ECIE AND &

EAJU_NUME OF FKAFCES = NUME_AJUS AND &

(ECES_STAT OF FKAFCES = "R" OR ECES_STAT OF FKAFCES = "")

 
The field I want to sort on is not indexed.  Any workaround possible???

Thanks!


-- 
Etienne Rompré
Directeur Marketing - Technologies
Marketing - Technologies Director

Kangouroute Inc. 
Location autos - camions
Car & Truck Rental
Québec Canada

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




> G'day Etienne
> 
> Are you saying that:
> 
> ACCESS ... ORDER BY ...
> SELECT IF ...
> 
> doesn't work for you?
> 
> Can we a sample of your code please?
> 
> Blue
> 
> PS.  What are kangaroos doing renting cars in Québec?
> 
> -----Original Message-----
> From: Etienne Rompré [mailto:rompre@kangouroute.com]
> Sent: Wednesday, May 28, 2003 12:22 PM
> 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 «order by» on my primary file in PhWEB after I
> made a »select if» on the same primary file?
> 
> Thanks!
>