From: KAOUANE (JIRA) <tr...@fi...> - 2012-12-29 21:30:24
|
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 |