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

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 >