Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oo40 help
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 GreszReceived on Fri Feb 06 1998 - 00:00:00 CST
>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 :-)