Keith Gray wrote:
>
> 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
What access method are you using ?
Doesn't rec.update cause an error ?
Anyway OpenDynamic isn't supported in any
access method.
regards,
Hiroshi Inoue