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: | 44EC1689.8080907@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Bart Samwel | 2006-08-23 12:55:40 | Output parameters problem |
Previous Message | Hiroshi Inoue | 2006-08-23 08:39:36 | Re: Parameters.Refresh and RETURN setof TEXT |