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

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