| From: | Info Agipa <info(at)apli-agipa(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
| Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | RE : MS-QUERY / Postgresql ODBC driver incompatibility |
| Date: | 2013-11-06 08:07:57 |
| Message-ID: | ADFDC855B3DED14E844ABDEF735A65875041C1FAD6@APLIEX01.exchange.apli.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
>So what if you do:
>
>select code as "groupe_clients", libelle
>from groupes_clients
I've got an error:
ERREUR: erreur de syntaxe sur ou près de << 'groupe_clients' >>;
Error while executing the query
>Also you might try creating the query in the Query Designer and
>specifying groupe_clients
>as the alias. This is how I do it I have not had any issues.
I've got the same error
I'm very surprised that you can make it.
It seems MS-QUERY use ' to quote an alias (containing a space or not).
And it seems that pgsql-odbc don't translate it to "
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nils Gösche | 2013-11-06 10:31:57 | Re: MS-QUERY / Postgresql ODBC driver incompatibility |
| Previous Message | Prabakaran, Vaishnavi | 2013-11-05 23:55:22 | Re: Configuration error in psqlodbc-09.02.0100 . Help needed! |