>> Inactive DB-trigger after Create/Alter Is Active
>> ------------------------------------------------
>>
>> Key: CORE-3418
>> URL: http://tracker.firebirdsql.org/browse/CORE-3418
>> Project: Firebird Core
>> Issue Type: Bug
>> Affects Versions: 2.5.0
>> Reporter: Maxim Kuzmin
>>
>>
>> After execute this query db-trigger is active:
>> CREATE OR ALTER TRIGGER TRG$START
>> INACTIVE ON TRANSACTION START POSITION 0 AS BEGIN
>> RDB$SET_CONTEXT('USER_SESSION', 'TRANS_ID',
>> CURRENT_TRANSACTION); END ^ SET TERM ; ^
>
> Can someone explain/elaborate on what the problem is. Maxim's entry is very
> "parse" on the details or the effect.
After creation of inactive database trigger it is really active.
As for effect - create such trigger and query value of contex variable
'TRANS_ID', it will be not null,
while should be NULL.
Regards,
Vlad
------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself;
WebMatrix provides all the features you need to develop and
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
