Order by with select if in PHWeb

[Peter Bateman]

Etienne:

  QUIZ or QTP could create a sorted subfile for you. If the screen is 
'display only' you could display the data from the subfile. If you need to 
update the data then you will need a clever unique linkage from the primary 
(subfile) to a secondary file ( real data file ).


>From: "Edis, Robert" <Robert.Edis@blistex.com>
>To: "Powerh-L (E-mail)" <powerh-l@lists.swau.edu>
>Subject: RE: Order by with select if in PHWeb
>Date: Wed, 28 May 2003 12:52:12 -0500
>
>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!
> >
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.  
http://join.msn.com/?page=features/junkmail