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

> -----Original Message-----
> From: Henshall, Stuart - WCP
> [mailto:SHenshall@westcountrypublications.co.uk]
> Sent: 18 April 2001 10:27
> To: 'Dave Page'; 'Hiroshi Inoue'
> Cc: 'Jean-Michel POURE'; 'pgsql-odbc@postgresql.org'
> Subject: RE: [ODBC] Access '97 {oj ...} Left Join
>
>
> 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.

Regards, Dave.