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

From Jeff Eckermann
Subject Re: Access, pass-through queries and isolation level
Date
Msg-id 20031107143100.33196.qmail@web20808.mail.yahoo.com
Whole thread Raw
In response to Re: Access, pass-through queries and isolation level  ("Philippe Lang" <philippe.lang@attiksystem.ch>)
List pgsql-odbc
On further thought, you may also want to debug your
Access code to make sure that the ReturnsRecords
property is not being reset somehow.

--- Philippe Lang <philippe.lang@attiksystem.ch>
wrote:
> I'm sending the two statements in one single
> pass-through query. Both statements are separated by
> a semicolon. I even tried to 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 add an 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 value is 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.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
settings


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Access, pass-through queries and isolation level
Next
From: Steve Wampler
Date:
Subject: Help with hang on empty query (PG 7.3.2, psqlodbc-07.03.0200)