Re: ADO and sequences

Andreas wrote:
>
>
> Hiroshi Inoue schrieb:
>> Andreas wrote:
>>> rs.AddNew
>>> lngID = rs!id
>> Try to get rs!id here is meaningless but
>>> rs!field1 = value1
>>> rs!field2 = value2
>>> ....
>>> rs.update
>> you can get rs!id here maybe.
>> Am I misunderstanding your point ?
>>> rs.close
>
> I tried this before my initial mail.
> Even though in the table definition is
> id serial not null,
> primary key (id)
> I still get rs!id = NULL after rs.addnew as well as after rs.update
>
> Maybe your driver behaves differently to the still official 08.01.0200?

The driver doesn't support Updatable Cursors.
Please install the 8.2.0002 version from the site
http://pgfoundry.org/projects/psqlodbc/
and turn on the Updatable Cursors option.

After that you can also use the snapshot driver at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html .
The registration is the same as the 8.2.0002 version and you
can simply replace the dll psqlodbc35w.dll.

Please note that you would be able to see the result after calling
update() not after Addnew().

regards,
Hiroshi Inoue