Order by with select if in PHWeb

[Markus Grossrieder]

Etienne,

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

Besides modifying the dictionnary ? You could generate a subfile (before
launching Quick, or from inside) in the desired order and use this subfile
as your primary, with all the restrictions using subfiles in Quick.

HTH, regards,
Markus

----- Original Message ----- 
From: "Etienne Rompré" <rompre@kangouroute.com>
To: "Edis, Robert" <Robert.Edis@blistex.com>
Cc: "Powerhouse List" <powerh-l@lists.swau.edu>
Sent: Wednesday, May 28, 2003 7:48 PM
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.
>
>