Re: Difference between ODBCdirect Connection and Pass-through-query - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Difference between ODBCdirect Connection and Pass-through-query
Date
Msg-id EKEJJICOHDIEMGPNIFIJIEBPHFAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Difference between ODBCdirect Connection and Pass-through-query  (DI Hasenöhrl <i.hasenoehrl@aon.at>)
List pgsql-odbc
-----Original Message-----
From: DI Hasenöhrl

> Hi,

> I use MsAccess97 as frontend and Postgresql as backend and till now I
thought, that there
> is no difference between a pass-through-query and a query,that I send via
ODBCdirect
> connection to postgresql. But now I have the followig miracle.

> If I make a pass-through-query with LEFT JOINs, I get the correct rows,
but by developing
> the syntax via VBA and transferring this code by an ODBCdirect connection,
I get only the
> rows of a normal INNER JOIN.

Please try the newest dll at http://w2422.nsk.ne.jp/~inoue/ .

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Kristis Makris
Date:
Subject: Re: 'infinity'::timestamp not translated correctly using
Next
From: Dave Page
Date:
Subject: Re: psqlODBC ODBC3.0/Column Names