Re: Serial columns and ADO

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Dmitry Samokhin <sdld(at)mail(dot)ru>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Serial columns and ADO
Date: 2006-11-10 00:41:42
Message-ID: 4553CAC6.5020001@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dmitry Samokhin wrote:
> As far as I understand, since the driver exposes 'serial' columns
> as 'AutoNumber', ADO issues 'SELECT @@IDENTITY' to retreive the new
> generated values just after inserts. The driver, in turn, has to modify that
> query into 'SELECT currval(...)'.
>
> When working with PG tables from inside MS Access, it all works perfectly!
> But here is a small test suite that doesn't work as expected:

Please try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dmitry Samokhin 2006-11-10 09:25:17 Re: Serial columns and ADO
Previous Message Dmitry Samokhin 2006-11-09 10:32:27 Serial columns and ADO