Re: Access, pass-through queries and isolation level - Mailing list pgsql-odbc

From Philippe Lang
Subject Re: Access, pass-through queries and isolation level
Date
Msg-id 6C0CF58A187DA5479245E0830AF84F420AF737@poweredge.attiksystem.ch
Whole thread Raw
In response to Access, pass-through queries and isolation level  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
Responses Re: Access, pass-through queries and isolation level
Re: Access, pass-through queries and isolation level
List pgsql-odbc
I'm sending the two statements in one single pass-through query. Both statements are separated by a semicolon. I even
triedto remove the carridge return at the end of the first statement, but of course, it has no effect. 

Postgres handles the sql commands fine. But I'm not able to get the return value from "func_test_insert", as soon as I
addan sql command BEFORE the function call. BUT, if I add this SQL command AFTER the function call, it's OK.
Apparently,the first statement is considered to be the one that returns data. All others are executed, but their return
valueis discarded. I guess this is an Access issue, more than an ODBC one, right? 

-----Message d'origine-----
De : Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
Envoyé : jeudi, 6. novembre 2003 16:35
À : Philippe Lang; pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Access, pass-through queries and isolation level

> Now if I want to change the isolation level before:
>
>    set transaction isolation level serializable;
>    select * from public."func_test_insert"();
>
> ... I cannot get the inserted id back in Access,
> from the pass-through query. Apprently, since the
> first query does not return any row, Access
> considers the whole query does not return anything.

Are you sending the two statements as separate queries
in your code?  If so, try sending both as a single
query, i.e. one string, with a semicolon separating
the two.  Access doesn't know you are sending two
statements in one, and Postgres will handle them just fine.


pgsql-odbc by date:

Previous
From: "Johann Zuschlag"
Date:
Subject: Re: ODBC
Next
From: TANIDA Yutaka
Date:
Subject: Bug in SQLColumns() and SQLTables() with "Parse Statement".