LS.

A
select id_klant, naam_klant, postcode
from klanten
order by id_klant, postcode

results in an AV (edbmngr -105b1)
odering by just one column is correct, more then one column gives the AV

B
It seems (read it from another NG -didnt know such a thing was possible-
that you could do

select id_klant, naam_klant, postcode
from klanten
order by 3,1

which should result in sorting on postcode and then id_klant. However it
doesn't.


Regards, Harry

Harry,

<< It seems (read it from another NG -didnt know such a thing was possible-
that you could do
 select id_klant, naam_klant, postcode
 from klanten  
 order by 3,1
>>

I think that a similar question (GROUP BY in that case) was referred to by Tim
in another post where he said:

<< "GROUP BY 1,2,3,5,6,7"  
You can't use this syntax in EDB since it isn't recommended in SQL 2003
anymore.  You need to use the actual column names and/or expressions
instead. >>

Cheers,
Dan

Dan,

Ok. I don't mind. An error/warning then would be in place, I guess. However
using column names (more then one) result in the bug (AV) I encountered.

Regards, Harry

"Dan Rootham" <roothamd@yahoo.co.uk> schreef in bericht
news:EF624686-0E8D-444C-BE3C-9963CE803058@news.elevatesoft.com...
> Harry,
>
> << It seems (read it from another NG -didnt know such a thing was
possible-
> that you could do
>   select id_klant, naam_klant, postcode
>   from klanten
>   order by 3,1
> >>
>
> I think that a similar question (GROUP BY in that case) was referred to by
Tim
> in another post where he said:
>
> << "GROUP BY 1,2,3,5,6,7"
> You can't use this syntax in EDB since it isn't recommended in SQL 2003
> anymore.  You need to use the actual column names and/or expressions
> instead. >>
>
> Cheers,
> Dan
>

Harry,

<< Ok. I don't mind. An error/warning then would be in place, I guess.
However using column names (more then one) result in the bug (AV) I
encountered. >>

We are aware of this problem and it has been fixed for 1.06.  Right now it
looks like 1.06 should be ready by Monday.

--
Tim Young
Elevate Software
www.elevatesoft.com