ADO and sequences

Поиск
Список
Период
Сортировка
От Andreas
Тема ADO and sequences
Дата
Msg-id 44EB410A.10809@gmx.net
обсуждение исходный текст
Ответы Re: ADO and sequences
Re: ADO and sequences
Список pgsql-odbc
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

     rs!field1 = value1
     rs!field2 = value2
....
rs.update
rs.close


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Rodney Franks"
Дата:
Сообщение: Re: Parameters.Refresh and RETURN setof TEXT
Следующее
От: "Johann"
Дата:
Сообщение: Re: ADO and sequences