Re: Auto Commit

From: A_Schnabel(at)t-online(dot)de (Andre Schnabel)
To: "Keith Gray" <keith(at)heart(dot)com(dot)au>, "PostgresSQL ODBC" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Auto Commit
Date: 2001-09-03 17:49:33
Message-ID: 004201c134a0$cb1be820$0201a8c0@aschnabel.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hmmm.. seem's there is a
rec.edit
missing before
rec = OpenDynamic(SQL)

Maybe this would help .. if not, check the settings of your ODBC-Datasource
(driversettings and datasourcesettings are readonly by default).

.. and yes, you should insert a rec.close before end of loop.

----- Original Message -----
From: "Keith Gray" <keith(at)heart(dot)com(dot)au>
To: "PostgresSQL ODBC" <pgsql-odbc(at)postgresql(dot)org>
Sent: Monday, September 03, 2001 8:40 AM
Subject: [ODBC] Auto Commit

> 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
>
> I tried inserting a rec.close before the end of the loop... ??
>
> Am I barking up the wrong tree? Should I check some Postgres
> Server Settings?
>
>
>
> --
> Keith Gray
>
> Technical Development Manager
> Heart Consulting Services P/L
> mailto:keith(at)heart(dot)com(dot)au
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-09-03 23:53:19 Re: Auto Commit
Previous Message Jochem van Dieten 2001-09-03 11:36:47 BIND variables & Windows ODBC driver