Oracle objects fro OLE oo40 help
From: Viswanatha Thalakola <thalakola_at_worldnet.att.net>
Date: 1998/02/05
Message-ID: <6be0j7$o6m_at_bgtnsc03.worldnet.att.net>#1/1
/
/
Date: 1998/02/05
Message-ID: <6be0j7$o6m_at_bgtnsc03.worldnet.att.net>#1/1
Hello ,
I am using version 2.1 of OO4O.
I have two tables.
create table T_3040_RECIEVED_TYPE
(
REC3040_ID NUMBER(4) not null, REC_DESCR VARCHAR2(50) not null,constraint PK_T_3040_RECIEVED_TYPE primary key (REC3040_ID) )
/
create table T_RECEIVED_FROM
(
RECEIVED_FROM_ID NUMBER(4) not null, RECEIVED_FROM_DESC VARCHAR2(50) not null, REC3040_ID NUMBER(4) not null,constraint PK_T_RECEIVED_FROM primary key (RECEIVED_FROM_ID) )
/
alter table T_RECEIVED_FROM
add constraint FK_REC_TYPE foreign key (REC3040_ID)
references T_3040_RECIEVED_TYPE (REC3040_ID)
/
I am not able to create an updatable oradynaset object for V_RECEIVED_FROM (which is a view of the table and is updatable).
set rst = oradatabase.createdynaset ("select * from V_RECEIVED_FROM",0&)
I am not sure why.
Similar tables with foreign key constraints appear to be updatable except this one.
I would appreciate ANY help on this.
Thank you.
Reddy Received on Thu Feb 05 1998 - 00:00:00 CET