Order by with select if in PHWeb

[Etienne Rompré]

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!


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



> 
> 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é [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 «order by» on my primary file in PhWEB after I
> made a »select if» on the same primary file?
> 
> Thanks!
>