I'll have mostly non-Firebird things on my mind the next week, so I'm
just unloading my latest comments now!
==============================================
p.117
Add a sentence to make it clear when the trigger is fired:
For mutation events, does the trigger fire at commit or at individual
insert/update/delete.
For two-phase-commit, it is described at p.122 (good!).
p.119:
"Declarations and embedded statements are terminated with semi-colons (;)."
For statements with a begin...end block, no semi-colon is used.
----------------------------------------
Simple "if":
BEGIN
IF (NEW.cust_no IS NULL) THEN
NEW.cust_no = GEN_ID(cust_no_gen, 1);
END
But, with a block of statements:
BEGIN
IF (NEW.cust_no IS NULL) THEN
BEGIN
NEW.cust_no = GEN_ID(cust_no_gen, 1);
END
END
p.248 reveals that
"The BEGIN and END statements have no line terminators."
This explains it, but:
a)
This is a trap for new users - please make a note around p.119 (about
semi-colons).
b)
"line terminators"? "statement terminator" seems better.
And "embedded statements" - are these just ordinary statements in the trigger?
----------------------------------------
p.124
ALTER TRIGGER set_cust_no INACTIVE;
Does this have immediate effect, even without a commit?
If a user inactivates a trigger, does something and then activates
the trigger - what is
the effect for users (in the inactive periode)? And, is it really
inactive (without a commit)?
I believe there has been some confused/confusing discussions on the
support list in the past on whether
a user can have a trigger de-activated just for himself. (He cannot, IIRC)
==============================================
--
Aage J.
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
_______________________________________________
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs
