Re: Auto Commit

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@heart.com.au>
To: "PostgresSQL ODBC" <pgsql-odbc@postgresql.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@heart.com.au
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)