Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Irwin Goldstein — — source: Informix-list mailing list archive (1991-1998)
Andreas Zeugswetter <andreas.zeugswetter@telecom.at> wrote in article
<356043EA.1A2A1064@telecom.at>...
> Does anybody know when
> select col_a from tab_a order by col_b;>
> will be supported ?
> The inability for Informix to process such statements makes it
> incompatible with
> MS Access V7 and up. It is not in IDS 7.3.
The OpenLink Multi-tier ODBC drivers detect the situation where you are
ordering by a column not in the select list and append the needed column(s)
to the select (throwing away the data retrieved). I'm not sure if the
"throw away" column gets transmitted over the network or not (I would
suspect not based upon the architecture of the product). I have had some
situations with older versions of OpenLink where this did not always work
correctly and I have not "stress tested" this using current versions, but I
have not encountered any specific problems with this lately.
HTH
Irwin Goldstein
Objective Software Systems, Inc.
http://www.objectsoft.com
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.