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]