Re: Auto Commit

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Keith Gray <keith(at)heart(dot)com(dot)au>
Cc: PostgresSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Auto Commit
Date: 2001-09-03 23:53:19
Message-ID: 3B9417EF.BFD71B26@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Keith Gray wrote:
>
> We are (of necessity) using a VB record set to update a database...
> works with MS-Access and MS-SQL.
>
> The current version (7.1) PostgreSQL and ODBC
> driver pair seems not to auto commit in this structure ??
>
> I have a loop with a ...
>
> while flag <> 0
> SQL = "SELECT blah... blah... blah..."
> rec = OpenDynamic(SQL)
> rec!stuff = rec!stuff + amount
> rec.update
> loop

What access method are you using ?
Doesn't rec.update cause an error ?
Anyway OpenDynamic isn't supported in any
access method.

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Marc Balmer 2001-09-04 13:28:15 ODBC Access from Visual Foxpro
Previous Message Andre Schnabel 2001-09-03 17:49:33 Re: Auto Commit