Boris Poliakovsky wrote : > >Dear Sirs, > >Could you please advise in the problem to create the trigger, >which I do >describe below ? > >MaxDB 7.5.0.16. on Windows XP. > >OLTP database. > >Database user - "DBA". > >Connection - MaxDB ODBC Driver > >Create trigger: >--------------------- >CREATE TRIGGER TR_BU_flow > FOR flow > AFTER UPDATE EXECUTE >( > UPDATE DBA.pd_general SET pd_calculated = '0' > WHERE cmpnt_id = :NEW.cmpnt_id > AND case_id = :NEW.case_id; >) > >Error message: >----------------------- >[MySQL MaxDB][SQLOD32 DLL][MaxDB] General error;-5016 POS(181) Missing >delimiter: ; > >Thanks, >Boris >---------
Your trigger syntax is absolutely correct and I have been able to create the trigger without any problems. Please send me a vtrace containing the failing create trigger statement. For vtrace please see http://sapdb.2scale.net/moin.cgi/VTrace Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
