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

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

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, 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 07:48:35
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2AAE@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> Sent: 12 April 2001 01:34
> To: Dave Page
> Cc: Henshall, Stuart - WCP; 'Jean-Michel POURE'; 
> 'pgsql-odbc(at)postgresql(dot)org'
> Subject: Re: [ODBC] Access '97 {oj ...} Left Join
> 
> 
> Dave Page wrote:
> 
> [snip]
> 
> > 
> > The driver reports that it is OJ capable if it is connected 
> to 7.1 or
> > higher. When I made the mods to the driver I tested 
> successfully the OJs did
> > work (this *may* not be the case if the Parse Statements option is
> > selected).
> > 
> > What doesn't work is the {oj...} style syntax as Stuart 
> reported (which
> > would have made my life easier when re-coding the SQL 
> Wizard in pgAdmin!),
> > but this is because PostgreSQL doesn't support it, not the driver.
> 
> As Henshall pointed out, {oj ...} style syntax seems a
> ODBC thing and the driver has to map the syntax to
> DBMS-specific syntax. In fact psqlodbc driver already
> supports {fn ..}, {dt ..} syntax etc ...
> In my simple test case, mapping the escape part as-is
> seems to work.

So the ODBC driver has to support syntax that isn't supported by the
backend? Hmm, I wasn't aware of that (not that that's unusual :-)).


Regards, Dave.

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-04-18 08:47:02
Subject: Re: Access '97 {oj ...} Left Join
Previous:From: Hiroshi InoueDate: 2001-04-17 00:18:07
Subject: ODBCINI in iODBC

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