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