oo40 help

From: Viswanatha Thalakola <thalakola_at_worldnet.att.net>
Date: 1998/02/05
Message-ID: <6be0kj$prv@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 CST