Skip site navigation (1) Skip section navigation (2)

Re: Serial columns and ADO

From: "Dmitry Samokhin" <sdld(at)mail(dot)ru>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Serial columns and ADO
Date: 2006-11-10 09:25:17
Message-ID: ej1ghi$1sa8$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Hiroshi-san,
I've tried your snapshot (8.2.0201) and found no difference in behaviour. It 
sends 'SELECT 0' as before. Is it really corrected in the snapshot? Maybe I 
have incorrect driver settings. Which ones affect most of all?
Dmitry.


"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> wrote in message 
news:4553CAC6(dot)5020001(at)tpf(dot)co(dot)jp(dot)(dot)(dot)
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
> 



In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2006-11-10 09:28:29
Subject: Re: Serial columns and ADO
Previous:From: Hiroshi InoueDate: 2006-11-10 00:41:42
Subject: Re: Serial columns and ADO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group