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]

Reply via email to