Re: oo40 help

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/02/06
Message-ID: <6bei2n$uor$2@news00.btx.dtag.de>#1/1

On Thu, 05 Feb 1998 22:45:03 -0500, Viswanatha Thalakola <thalakola_at_worldnet.att.net> wrote:
Hi,

would be nice to see V_RECEIVED_FROM.

--

Regard 
Matthias Gresz



>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


--

Regards

Matthias Gresz    :-)

Received on Fri Feb 06 1998 - 00:00:00 CST