Using the Intersolve ODBC driver 3.10, there is a documented workaround for
this case. The new 3.11 driver can not handle this, but Intersolve is on
the way to fix it.
Jens
Klaus Gotthardt <k.gotthardt@em.uni-frankfurt.de> schrieb im Beitrag
<35F8CBB5.3969@em.uni-frankfurt.de>...
> I tried using ms-access(97) as a frontend to informix(7.23,cli 2.5). It
> worked, but i can sort only fields which are primary keys.
>
> (error: ....order by column (...) must be in select list (# -309))
>
>
> --
> Klaus Gotthardt,
> Johann Wolfgang Goethe-Universit't,Verwaltungsdatenverarbeitung
> Email: K.Gotthardt@em.uni-frankfurt.de
> Tel:+49 (0)69-798-23380
> Fax:+49 (0)69-798-23381
> Home,pgp-key: http://www.rz.uni-frankfurt.de/~gotthard
>