Hi Listmembers,
I try to define a updateable join view with the followin statements:
CREATE TABLE WWIND.KD (
KUNDENNR FIXED(10) default serial PRIMARY KEY,
FIRMA CHAR(40) NOT NULL,
KONTAKTPERSON CHAR(30),
FUNKTION CHAR(30)
)
//
CREATE TABLE WWIND.ADR (
ADRESSNR FIXED(10) PRIMARY KEY,
STRASSE CHAR(60),
ORT CHAR(15),
REGION CHAR(15),
PLZ CHAR(10),
LAND CHAR(15),
TELEFON CHAR(24),
TELEFAX CHAR(24),
FOREIGN KEY (ADRESSNR) REFERENCES WWIND.KD ON DELETE CASCADE
)
//
CREATE VIEW WWIND.VKUNDEN AS
SELECT
K.KUNDENNR,
K.FIRMA,
K.KONTAKTPERSON,
K.FUNKTION,
A.STRASSE,
A.ORT,
A.REGION,
A.PLZ,
A.LAND,
A.TELEFON,
A.TELEFAX
FROM WWIND.KD K INNER JOIN WWIND.ADR A
ON K.KUNDENNR = A.ADRESSNR
WITH CHECK OPTION
After commiting these statements to the DB I am able to insert records
through the view by the following statement:
INSERT INTO WWIND.VKUNDN (FIRMA, STRASSE, ORT, PLZ, LAND, KUNDENNR)
VALUES ('Company', 'Streetname', 'Cityname', '12345', 'DE', 100)
But when I try to delete or update the record by one of the following
statements I receive an errormessage :(
UPDATE WWIND.VKUNDEN SET FIRMA = 'Firmenname' WHERE KUNDENNR = 100
//
DELETE FROM WWIND.VKUNDEN WHERE KUNDENNR = 100
The DBMS states in both cases:
Base table not found; -4004 POS(xy) Unknown table name:VKUNDEN
So this seems not be an updateable view. Can someone please explain what is
the reason for this and how I can modify the view- or tabledefinitions to
get an updateable join view?
Thanks a lot & Best regards
--
10 GB Mailbox, 100 FreeSMS/Monat http://www.gmx.net/de/go/topmail
+++ GMX - die erste Adresse für Mail, Message, More +++
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
