Hi @all, i need some advice with an trigger statement. When i execute this statement in the SQL Studio, i became this error. ---- Error ------------------------------- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed Syntax error or access violation;-3005 POS(1) Invalid SQL statement. VAR masch SMALLINT; -------------------------------------------
The Trigger Statement: CREATE TRIGGER trichter_falzwerk FOR TRICHTER_FALZWERK AFTER INSERT, UPDATE (PRODUKTIONSLAUF, TRICHTER) EXECUTE ( -- explizite angabe des Datentyps VAR masch SMALLINT; SELECT MASCHINE into :masch FROM ADABAS.PRODUKTIONSLAUF WHERE IDX= :NEW.PRODUKTIONSLAUF; SELECT * FROM ADABAS.TRICHTER WHERE NUMMER= :NEW.TRICHTER and MASCHINE= :masch; IF ($rc<>0) THEN STOP( -1, 'INSERT, UPDATE: TRICHTER_FALZ->TRICHTER nicht vorhanden'); ) I hope someone can help me Thanks in advance Best Regards Markus Franz -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
