[SQL] question about "ORDER BY" statement

[SoftIl]

Hi Ruslan,
thanks, it works wondeful! :-))

Best regards,
Carsten

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Tuesday, October 21, 2003 8:29 PM
Subject: Re: [SQL] question about "ORDER BY" statement


> on 10/21/03 21:25, SoftIl at softil at onlinehome.de wrote:
>
> > Hi Ruslan,
> >> You need to use BaseObject method to get this
> > Which method do you mean?
>
>
> You need create BaseObject method
>
>     FldLwr = lower(fld)
>
> And use it in query
>
>     SELECT fld FROM T ORDER BY fldLwr
>
>
> > Best regards,
> > Carsten
> >
> >
> >> ----- Original Message -----
> >> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> >> To: <valentina at lists.macserve.net>
> >> Sent: Tuesday, October 21, 2003 11:10 AM
> >> Subject: Re: [SQL] question about "ORDER BY" statement
> >>
> >>
> >>> on 10/21/03 11:59, SoftIl at softil at onlinehome.de wrote:
> >>>
> >>>> Hi,
> >>>> if there is a possibility to supplement the "order by" sql-statement
> >> with
> >>>> "no_case"?
> >>>> Example:
> >>>> "select * from TableName order by FieldName no_case"  //that
statement
> >> gets an
> >>>> error back "field no found".
> >>>
> >>> Hi Carsten,
> >>>
> >>> You need to use BaseObject method to get this
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>