Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
order by (bug?) |
Thu, Oct 25 2007 6:55 AM | Permanent Link |
"Harry de Boer" | 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 |
Fri, Oct 26 2007 9:10 AM | Permanent Link |
Dan Rootham | 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 |
Fri, Oct 26 2007 11:25 AM | Permanent Link |
"Harry de Boer" | 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 > |
Fri, Oct 26 2007 4:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |