Re: Transactions, PostgreSQL and MS Access front end. - Mailing list pgsql-general

From vladimir
Subject Re: Transactions, PostgreSQL and MS Access front end.
Date
Msg-id e2i7g0$2ff9$1@news.hub.org
Whole thread Raw
In response to Transactions, PostgreSQL and MS Access front end.  ("Karen Hill" <karen_hill22@yahoo.com>)
List pgsql-general
Karen Hill wrote:

>From Access I'd like to run pass the following from MS Access to
> PostgreSQL 8.1 using VBA:
>
> BEGIN;
> UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345;
> UPDATE accounts SET balance = balance - 100.00 WHERE acctnum = 7534;
> COMMIT;
>
> It won't let me.  Any ideas solutions?

it should work in pass-through query, and the query could be generated by
code (AFAIK, it has been a while i did Access).

vlad

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Postgreql 8.0.3 temporary Table Strange behaviour
Next
From: "Nicolas Barbier"
Date:
Subject: Re: to know