Please Remove me from the list

-----Original Message----- From: larry.linson@ntpcug.org <larry.linson@ntpcug.org> To: informix-list@iiug.org <informix-list@iiug.org> Date: Sunday, March 21, 1999 7:52 PM Subject: Re: MS-Access: can't sort linked INFORMIX table? > pmpg_No Spam_98@Hotmail.com (Pedro Gil ) wrote: > > But think that the problem reside in the ODBC driver or CLI can > > decide. > > > > What i can say too you more than you allready explain, is that if you > > don't have the index created in the Informix, you will not be able to > > sort that field in any query or table. > > > > The turn around that problem for me was, to create Query Pass-through > > that way you can retrive data sorted that doesn't have indexes created > > in the INFORMIX. > >Obviously, one could get the Informix DBA to create an index on the field or >create one yourself if you do Informix DBA work. An appropriate passthrough >query should solve the problem. Another solution would be to create a View in >Informix with the appropriate ORDER BY clause. > >As I understand it, this is a problem with the way Jet handles the queries it >sends to the server (Informix) -- they differ from what you see in Access, >even in SQL view. I don't think InterSolv is going to be able to solve it for >you. And, of course, as you point out, you get the erroneous message even >though the field _IS_ in your select list. > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >