The stored procedure can not inactive Trigger ---------------------------------------------
Key: CORE-4023 URL: http://tracker.firebirdsql.org/browse/CORE-4023 Project: Firebird Core Issue Type: Bug Affects Versions: 2.5.1 Environment: Windows Reporter: KAOUANE I have trigger MDF_VEHICULE active on after update table; I have a stored procedure who update this table but I want to diactive trigger inside this procedure and activate it at last. In core of SP I write : EXECUTE STATEMENT 'ALTER TRIGGER MDF_VEHICULE INACTIVE'; UPDATE VEHICULE SET VALIDE = 1; .... EXECUTE STATEMENT 'ALTER TRIGGER MDF_VEHICULE ACTIVE'; When I execute SP, I find that trigger are not inactive. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122912 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel