Re: Access '97 {oj ...} Left Join

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "'Henshall, Stuart - WCP'" <SHenshall(at)westcountrypublications(dot)co(dot)uk>, "'Jean-Michel POURE'" <jm(dot)poure(at)freesurf(dot)fr>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Access '97 {oj ...} Left Join
Date: 2001-04-18 11:42:59
Message-ID: 3ADD7DC3.7ED2EFF1@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dave Page wrote:
>
> > -----Original Message-----
> > From: Henshall, Stuart - WCP
> >
> > FYI Here's a little snippet from the ODBC 3.0 SDK:
> > Applications can submit statements using ODBC or DBMS-specific
> > grammar. If a statement uses ODBC grammar that is different from
> > DBMS-specific grammar, the driver converts it before sending
> > it to the data
> > source. However, such conversions are rare as most DBMSs already use
> > standard SQL grammar.
> > I think the Idea is to make a client program using ODBC
> > able to use
> > any backend as long as it supports the features that are being used.
> > Btw, if any one makes a build that solves the {oj ...}
> > problem (wether by
> > supporting it or disabling it) please could they pop me a
> > copy (or make such
> > a copy available) as I don't have M$VC,
> > Thanks,
> > - Stuart
>
> If Hiroshi is fixing it (are you - you mentioned some test code?) then at a
> convenient point (when everyone isd happy) I'll do a build and package it up
> ready to go on ftp.postgresql.org - I'll also announce it on the ODBC list.
>

I mailed a patched dll to Stuart and it seems to have worked.
I would commit it together with other patches in a convenient
point.

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2001-04-18 12:03:02 RE: Access '97 {oj ...} Left Join
Previous Message Tibor Laszlo 2001-04-18 11:35:30 RE: New ODBC psqlodbc-07_01_0004.zip