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