| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Keith Gray <keith(at)heart(dot)com(dot)au> |
| Cc: | PostgresSQL ODBC <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: Auto Commit |
| Date: | 2001-09-03 23:53:19 |
| Message-ID: | 3B9417EF.BFD71B26@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Balmer | 2001-09-04 13:28:15 | ODBC Access from Visual Foxpro |
| Previous Message | Andre Schnabel | 2001-09-03 17:49:33 | Re: Auto Commit |