BorlandTalk.com

Kurt Bilde · Guest

Hi !

Using ODAC 4.50.2.20 for Delphi 7.

I'm having problems with retrieving the value of the KeyField right
after the post with TOraTable e.g..:

dmMySam.taFagbeskrivelse.Post;
IKlonRunNr := dmMySam.taFagbeskrivelseFAGBESKRIVELSE_ID.value;

The Sequence Mode is set to smPost.

I've tried with dmMySam.taFagbeskrivelse.RefreshRecord; e.g.:

dmMySam.taFagbeskrivelse.Post;
dmMySam.taFagbeskrivelse.RefreshRecord;
IKlonRunNr := dmMySam.taFagbeskrivelseFAGBESKRIVELSE_ID.value;

But without any luck.

I've created a Sequence like this:
CREATE SEQUENCE FAGBESKRIVELSE_ID_SEQ
START WITH 1
INCREMENT BY 1
MAXVALUE 999999
MINVALUE 1
NOCACHE
NOORDER;

and the table looks like this:

/* Table: FAGBESKRIVELSE */
CREATE TABLE FAGBESKRIVELSE (
FAGBESKRIVELSE_ID NUMBER(6, 0) CONSTRAINT
FAGBESKRIVELSE_ID_PK PRIMARY KEY,
PERIODESTART_ID NUMBER(3, 0) ,
PERIODESLUT_ID NUMBER(3, 0) ,
STATUS_ID NUMBER(3, 0) ,
WEBSTATUS_ID NUMBER(3, 0) );

Can anyone see why I doesn't get the Sequence value back just after
posting?????

If some have any comments on my approach on the Sequence or have any
hint they are highly appreciated

tia

-Kurt