Skip site navigation (1) Skip section navigation (2)

Re: Difference between ODBCdirect Connection and Pass-through-query

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "DI Hasen?rl" <i(dot)hasenoehrl(at)aon(dot)at>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Difference between ODBCdirect Connection and Pass-through-query
Date: 2002-03-30 09:00:42
Message-ID: EKEJJICOHDIEMGPNIFIJIEBPHFAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: 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


In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-03-30 09:01:00
Subject: Re: ODBCdirect and MsAccess97
Previous:From: Kristis MakrisDate: 2002-03-29 16:38:24
Subject: Re: 'infinity'::timestamp not translated correctly using

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group