From: "Artur" <aerton@poczt.onet.pl>
Newsgroups: comp.databases.oracle.misc
Subject: Triggers and ADO
Date: Wed, 8 Aug 2001 12:03:43 +0200
Organization: news.onet.pl
Lines: 30
Sender: aerton@poczta.onet.pl@pc58.warszawa.sdi.tpnet.pl
Message-ID: <9kr2qq$gsc$1@news.onet.pl>
Reply-To: "Artur" <aerton@poczt.onet.pl>
NNTP-Posting-Host: pc58.warszawa.sdi.tpnet.pl
X-Trace: news.onet.pl 997265050 17292 213.25.56.58 (8 Aug 2001 10:04:10 GMT)
X-Complaints-To: abuse@onet.pl
NNTP-Posting-Date: 8 Aug 2001 10:04:10 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200


Hi
    I am having a problem with adding new records to a table using ADO. A
table has unique column named "ID".
When I adding new row to the table I use trigger ( SQ_MY_TABLE_ID is a
sequence) :

CREATE OR REPLACE TRIGGER TR_MY_TABLE_INSERT
BEFORE INSERT ON MY_TABLE
FOR EACH ROW
BEGIN
 SELECT SQ_MY_TABLE_ID.nextval INTO :new.ID FROM DUAL;
END;

To add new data I use:
_variant_t val("My String")
m_Recordset->AddNew();
m_Recordset->Fields->GetItem(2)->Value = val;
m_Recordset->Update();

val = m_pRS->Fields->GetItem("ID")->Value;
// variable val CONTAINS "ID" = 0 ???????
How can I get those ID ?????

Thank you,
Artur