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

Re: ADO and sequences

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ADO and sequences
Date: 2006-08-23 08:49:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Andreas wrote:
> Hi,
> I'd like to write to PG from Access2000 with ADODB.
> I got it running, but I'd like to know the sequence-nr that gets used 
> when a new record is created.
> I open a recordset with
>        .CursorLocation = adUseClient
>        .CursorType = adOpenStatic
>        .LockType = adLockOptimistic
> then I call its AddNew method, the columns get filled and the recordset 
> is closed.
> The primary key is a SERIAL.
> Is there a way to read the pkey before I commit the record?
> Access knows it's Autonumbers after AddNew when I use it's JET db-engine.
> A "select currval...." after the AddNew yields
> Error while executing the query;
> ERROR:  currval of sequence "personen_person_id_seq" is not yet defined 
> in this session
> I'd rather not use currval anyways. I'd prefer to have the program not 
> know to much of the structure that sits in the db backend, like the 
> sequence's name in this case.
> Can I get something like this :
> 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

Hiroshi Inoue

In response to


pgsql-odbc by date

Next:From: Bart SamwelDate: 2006-08-23 12:55:40
Subject: Output parameters problem
Previous:From: Hiroshi InoueDate: 2006-08-23 08:39:36
Subject: Re: Parameters.Refresh and RETURN setof TEXT

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