Re: [HACKERS] Access & Postgres

This question may be better posted on the interfaces list.

See:  http://www.insightdist.com/psqlodbc
Visit the FAQ.   It is one of the last items listed.

Sferacarta Software wrote:

> Hi all,
> I have this problem:
>
> This sample query create with Access
>
> SELECT figure.*, utenti.ragione_sociale
> FROM figure INNER JOIN utenti ON figure.codice_figura = utenti.azienda;
>
> via-psqlODBC reports this
>
> ERROR:  The field being ordered by must appear in the target list'
> STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
>
> Postgres executes this sql query (I find this in Psqlodbc.log file) :
>
> SELECT figure.oid,utenti.azienda
> FROM utenti,figure WHERE (figure.codice_figura = utenti.azienda ) ORDER BY figure.codice_figura
>
> Why is there ORDER BY CLAUSE ?
> Why is there only "figure.oid" instead of "figure.*" in SELECT
> arguments ??????
>
> Best regards,
>  Marco Pollachini
>  Sferacarta                          mailto:sferac@bo.nettuno.it