Skip site navigation (1) Skip section navigation (2)

Auto Commit

From: Keith Gray <keith(at)heart(dot)com(dot)au>
To: PostgresSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Auto Commit
Date: 2001-09-03 06:40:51
Message-ID: 3B9325F3.1166FEBE@heart.com.au (view raw or flat)
Thread:
Lists: pgsql-odbc
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

Responses

pgsql-odbc by date

Next:From: Jochem van DietenDate: 2001-09-03 11:36:47
Subject: BIND variables & Windows ODBC driver
Previous:From: Dave PageDate: 2001-08-31 16:19:06
Subject: Re: pgAdmin/ODBC errors.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group