Re: ORDER BY doesn't work

From: Alexander Zeh <azeh@gss-online.de> > >I'm working with Access SR-2 ,Windows NT4 and the ODBC -driver INFORMIX >3.31 32 BIT and some SQL -statements do not work. > >1. Sorting the result on a column which is not the primary key stops >with the errormessage: > ORDER BY column (columnname) must be in SELECT list (#-309) > This error occurs also with a statement like "SELECT Name FROM >Personal ORDER BY Name" > >2. When I try to update more than 1000 records in two tables using one >statement with an INNER JOIN, an ODBC -error occurs: Joinexpression not >suported. With less than 1000 records it works. > >on the Informix SE all statements are working fine which do not work >with Access. Well, there's a hint there, isn't there? I don't know about the second, but the first is a known hassle with Access -- it doesn't adhere to the ANSI standard of requiring that columns in the ORDER BY must be in the SELECT list. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com