Please remove my name and the email address from your e-mailing list. Thank you !
> -----Original Message-----
> From: [EMAIL PROTECTED]@PILLSBURY On Behalf Of "Anhaus,
>Thomas" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 17, 2002 9:14 AM
> To: [EMAIL PROTECTED]
> Cc: '[EMAIL PROTECTED]'
> Subject: RE:Why is this view readonly?
>
> ralf schneider wrote :
>
> >Hi,
>
> >I want to create a view with the following SQL statement:
>
> >CREATE VIEW k_0001_combobox_texts AS
> >SELECT A."tid", A."language", A."text", A."abbrev"
> >FROM combobox_texts A, combobox B
> >WHERE A."tid" = B."tid" AND B."cip" = 3
> >WITH CHECK OPTION
>
> >The two tables combobox_texts and combobox are defined as follows:
>
> >CREATE TABLE combobox
> >(
> > "type" VARCHAR(16),
> > "tid" SMALLINT,
> > "order" SMALLINT,
> > "delete_it" BOOLEAN DEFAULT FALSE,
> > "cip" INTEGER,
> > PRIMARY KEY ("tid", "cip")
> >)
>
> >CREATE TABLE combobox_texts
> >(
> > "tid" SMALLINT,
> > "language" VARCHAR(16),
> > "text" VARCHAR(64),
> > "abbrev" VARCHAR(3),
> > PRIMARY KEY ("tid", "language")
> >)
>
> >When I execute the CREATE VIEW statement I get the error message:
>
> >[SAP DB]General error;-7051 POS(1) Read only view WITH CHECK OPTION not
> >allowed.
>
> >But why? What do I have to do for being able to create an editable view?
>
> Your view is a join view. Join views can only be updatable,
> if you have 1 : n releationships between the tables involved.
> These 1 : n relationsships have to be defined as foreign keys.
> None of your table contains a foreign key definition, therefore the view is read
>only.
> It's not clear for me, which columns of what table should form your foreign key.
> For further information please see
>
> http://www.sapdb.org/htmhelp/e0/ed9036dfe4b903e10000009b38f889/frameset.htm
>
> Thomas
> --
> Thomas Anhaus
> SAP DB, SAP Labs Berlin
> [EMAIL PROTECTED]
> http://www.sapdb.org/
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
