Hi Listmembers, what is wrong here:
CREATE TABLE WWIND.Kunden ( KundenNr FIXED(10) DEFAULT SERIAL PRIMARY KEY, Firma VARCHAR(40) NOT NULL, Kontaktperson VARCHAR(30), Funktion VARCHAR(30), Strasse VARCHAR(60) NOT NULL, Ort VARCHAR(15) NOT NULL, Region VARCHAR(15), PLZ VARCHAR(10) NOT NULL, Land VARCHAR(15) NOT NULL, Telefon VARCHAR(24), Telefax VARCHAR(24)) // CREATE TRIGGER it_kontaktinfo FOR WWIND.KUNDEN AFTER INSERT EXECUTE ( IF (KONTAKTPERSON IS NULL OR KONTAKTPERSON = '') AND FUNKTION IS NOT NULL THEN STOP (30001, 'Funktion ohne Kontaktperson ist nicht erlaubt'); ) // CREATE TRIGGER ut_kontaktinfo FOR WWIND.KUNDEN AFTER UPDATE EXECUTE ( IF (NEW.KONTAKTPERSON IS NULL OR NEW.KONTAKTPERSON = '') AND NEW.FUNKTION IS NOT NULL THEN STOP (30002, 'Funktion ohne Kontaktperson ist nicht erlaubt'); ) // INSERT INTO KUNDEN (KundenNr, Firma, Kontaktperson, Funktion, Strasse, Ort, Region, PLZ, Land, Telefon, Telefax) VALUES (1,'Alfreds Futterkiste','Maria Anders','Vertriebsmitarbeiterin','Obere Str. 57','Berlin', '','12209','Deutschland','030-0074321','030-0076545') Execution of the above statements on MaxDB 7.6.00.12 (Windows XP) results in the following errormessage: ---- Error ------------------------------- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed General error;-9111 INSERT INTO KUNDEN (KundenNr, Firma, Kontaktperson, Funktion, Strasse, Ort, Region, PLZ, Land, Telefon, Telefax) VALUES (1,'Alfreds Futterkiste','Maria Anders','Vertriebsmitarbeiterin','Obere Str. 57','Berlin', '','12209','Deutschland','030-0074321','030-0076545') Marked in red are 'NSERT' of the INSERT-Statement (Yes, the 'I' is not marked!). The reason for the error seems to be caused by the triggers as the error will not occur when creating the table and inserting the record without having defined the triggers. This example demonstrates the problem with showing defined triggers I mentioned some days before (see '[FSID] DOMAIN.TRIGGERS always empty!?'): Execute the above statements without the INSERT-Statement. On my MaxDB-installations this will not result in an errormessage and the table will be shown in the catalog-manager of SQL Studio while the triggers are not shown there. SELECT COUNT(*) FROM TRIGGERS resuults in '0', but when I try to define a INSERT-Trigger on WWIND.KUNDEN the system states a "6006 - Duplicate name" Who can explain these phenomenons? THX & 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]
