Triggers and ADO

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 Received on Wed Aug 08 2001 - 05:03:43 CDT