complicated Method construction

[Steve Albin]

On Friday, March 2, 2007 sunshine at public.kherson.ua (Ruslan Zasukhin) wrote:

>On 2/3/07 12:01 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:
>
>> So if I don't use it in the SELECT clause, I can use it in the WHERE
>> and also in ORDER BY .
>> Correct?
>
>In WHERE - yes.

This has not been my experience.  I had a case where a field used in the WHERE clause but not specified in the SELECT clause crashed my app.  User complained and I changed this one thing and the app was fine.  I'm using V4RB 2.5.4.  


>
>In ORDER BY prohibited by Standard.
>Seems we have not allow it yet.
>I not remember. Easy to check
>    select f1 from T ORDER BY f2
>
-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/