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