ORDER BY

[jda]

>
>
>>  In V1.x I could ORDER a cursor by a field I did not select.
>>
>>  It seems that this causes an error in V2.0. Is that correct -- it is
>>  no longer allowed and you must select the field you ORDER by?
>
>Hmm, as I remember, on start Valentina 1.x did allow this.
>Later when GROUP BY was implemented Valentina 1.x also prohibit this.
>So are you sure that in Valentina 1.10 you could do this ?!

Yes, I have examples where it works in 1.x (I don't ever use GROUP 
BY, if that matters).

>
>And yes. SQL92 do not allow this.
>Because ORDER BY sorts NEW result table in general case.
>
>Because ORDER BY also have syntax
>
>     ORDER BY 1, 2
>
>To refer fields from SELECT rule.
>

OK, thanks.

Jon