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?
Thanks in advance
Peter
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
