Re: Auto Commit

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