Order by with select if in PHWeb

[Markus Grossrieder]

Sorry for that, I did't see the other (and way more informative) answers !
Not enough sleep ... we have kind of long nights here in Geneva at the
moment

Regards,
Markus

----- Original Message ----- 
From: "Markus Grossrieder" <markus.grossrieder@alba-systems.com>
To: "Etienne Rompré" <rompre@kangouroute.com>
Cc: "Powerhouse List" <powerh-l@lists.swau.edu>
Sent: Friday, May 30, 2003 1:34 PM
Subject: Re: Order by with select if in PHWeb


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