Peter Huebschen wrote :
>Hello,
>I don't know what's wrong with my Create View-Statement. I always get "Read
>only view WITH CHECK OPTION not allowed", but I need a updatable view.
>Here's my statement:
>CREATE VIEW "VIEW_DSCOPY"
>AS SELECT tbl_teile.teilenummer,
> tbl_teile.lfd_Anfragenummer,
> tbl_teile.Teilebezeichnung,
> tbl_teile.Maschinen_ID,
> tbl_StaffelTeil.angefr_Volumen,
> tbl_StaffelTeil.lfdNr_Teile,
> tbl_StaffelTeil.Bemerkung_Teilepreis,
> tbl_StaffelTeil.Bemerkung_WKZ_Kosten
>FROM tbl_Teile, tbl_StaffelTeil
>WHERE tbl_Teile.lfdnr_teile = tbl_Staffelteil.lfdnr_Teile WITH CHECK OPTION
>The tables has these constraints:
>tbl_Teile: with a third table which isn't include in the view
>tbl_Staffelteil: FOREIGN KEY "REF_TEIL_STAFFFEL" ("LFDNR_TEILE")
>REFERENCES "ALLUSERS"."TBL_TEILE" ("LFDNR_TEILE") ON DELETE CASCADE
>Did I miss something in the docs?
Did you define a key for table tbl_Staffelteil. If not, that's the problem. If you
did, please send me the definitions of the tables tbl_Teile and tbl_Staffelteil.
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
