Can't create updatable view
"Hübschen, Peter" <[email protected]> Mon, 1 Sep 2003 10:49:18 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <5037282E0DC5D711974C00304852417A025E6A@SERVER-XCH> |
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