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

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-16 14:02:07
Message-ID: 455C6F5F.7000203@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Dmitry Samokhin wrote:
>>> Could you try to set the Extra Opts option to 0x2 ?
>>>       
>> With the current snapshot, please.
>> I was able to reproduce the behavior here.
>>
>> regards,
>> Hiroshi Inoue
>>     
>
> OK, now it works! Thanks for your attention.
> But with Extra Opts = 0x0 it still issues 'SELECT 0' and assignes 0 to an 
> identity field. IMHO, if I don't want to read any server-assigned defaults 
> for a newly inserted row, any field not set explicitly should contain NULL 
> both before and after insert operation, not 0.
>   

OK try the snapshot dll.
0x2 Extra Opts option is no longer needed for the case.
Also changed to SELECT NULL in case of failure.

regards,
Hiroshi Inoue


In response to

Responses

pgsql-odbc by date

Next:From: Ezequias Rodrigues da RochaDate: 2006-11-16 14:54:02
Subject: Apoie o estudo das células tronco
Previous:From: noreplyDate: 2006-11-16 07:45:05
Subject: [ psqlodbc-Bugs-1000778 ] Error 3219 - Operation is not allowed in this context - Blobs and VB6

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