Hello,
should a trigger like the following on fb 2.5.(2 snapshot) fire when
attaching via service api? It does not in my tests.
SET TERM ^ ;
CREATE OR ALTER TRIGGER DB_BI0
ACTIVE ON CONNECT POSITION 0
AS
begin
if (upper(current_role) = 'NONE') then
EXCEPTION PARAMINVALID 'Please use a role...';
end
^
SET TERM ; ^
Why?
I can imagine that there might be problems because of the context (No
transaction ...) but such tests like above should work, don't they?
--
Björn Reimer - RRZE
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
