Re: Order by Problem in Select - VB -> Q+E ODBC -> INFORMIX 6.0

In article <kcjDAuC53.90q@netcom.com> kcj@netcom.com (Kate Juliff) writes: >Newsgroups: comp.databases.informix >Path: logica.co.uk!plug.news.pipex.net!pipex!soap.news.pipex.net!pipex!edi.news.pipex.net!pipex!news.sprintlink.net!noc.netcom.net!ix.netcom.com!netcom.com!kcj >From: kcj@netcom.com (Kate Juliff) >Subject: Re: Order by Problem in Select - VB -> Q+E ODBC -> INFORMIX 6.0 >Message-ID: <kcjDAuC53.90q@netcom.com> >Organization: Netcom Online Communications Services (408-241-9760 login: guest) >References: <3snmls$3g1@ixnews6.ix.netcom.com> >Date: Tue, 27 Jun 1995 16:51:03 GMT >Lines: 30 >Sender: kcj@netcom21.netcom.com >In article <3snmls$3g1@ixnews6.ix.netcom.com> venki@ix.netcom.com (Venkatesh Rajah) writes: >>Hi, >> >> The problem we are facing is very simple, >> >> select A, B >> from Table1 >> order by A>> >> if A is defined as a character column in the table the select >> statement gives a error >> >> "Invalid Order by Column" >> >> The same works when it is made pass through and thru ISQL. >> >I'm sorry I can't help. I have the same problem. All I need to >do is produce a sorted list from a three column table. But the >INFORMIXSERVER disconnects whenever I type >"select column1, column2, column3 from tablename order by colum1. >It would seem a simple enough statement and I've >even tried to set up a view to sort, but get the same >problem. I have SE V7.1 >Kate Juliff >> Hi, From memory, I think that the ODBC drivers conform to various different "Conformance Levels". So drivers at Level 0, typically do not support "Complex" SQL queries, such as order by, while drivers at level 1 do. I think that the best place to start is to ask the driver manufacturer which Conformance Level their drivers conform to. Also I recommend that you get hold of the following books : "Database developer's Guide with Visual Basic 3" by Roger Jennings, Sams Publishing ISBN : 0-672-30440-6 "Microsoft ODBC 2.0 Programmer's Reference and SDK Guide" Microsoft Press ISBN 1 - 55615-658-8 There is also a Microsoft Paper available from their Net site which describes the workings of ODBC and the Jet Engine. Jitinder | The views expressed here, unless otherwise specified, | | reflect or represent the views of neither Logica UK Ltd | | nor any of its partners, franchisees, | | distributers, agents, nor any of their shareholders, | | except the author who is acting on behalf of himself. | From memory