> 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 :
> lngID = rs!id
Try to get rs!id here is meaningless but
> rs!field1 = value1
> rs!field2 = value2
you can get rs!id here maybe.
Am I misunderstanding your point ?
In response to
pgsql-odbc by date
|Next:||From: Bart Samwel||Date: 2006-08-23 12:55:40|
|Subject: Output parameters problem|
|Previous:||From: Hiroshi Inoue||Date: 2006-08-23 08:39:36|
|Subject: Re: Parameters.Refresh and RETURN setof TEXT|