Download and use FlameRobin .... easiest way!
This message is intended only for the use of the individual or entity to which
it is addressed, and may contain information that is privileged, confidential
and exempt from disclosure under applicable law. If the reader of this message
is not the intended you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If you
are not the intended reader, then you must destroy this communication
immediately.
From: 陈文欢 <9183...@qq.com>
To: firebird-net-provider <firebird-net-provider@lists.sourceforge.net>
Sent: Saturday, July 2, 2016 3:25 AM
Subject: [Firebird-net-provider] some questions about Firebirsql
hi,guys
i have a question about how to create trigger.
when i use the Firebird .net Provider 5.0 . i dont kown how to create the
commandtext for trigger.
e.g
SET TERM ^ ;
CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSETACTIVE BEFORE INSERT POSITION
0ASDECLARE VARIABLE tmp DECIMAL(18,0);BEGIN IF (NEW.RD IS NULL) THEN NEW.RD
= GEN_ID(GEN_TCURRENTSET_RD, 1); ELSE BEGIN tmp =
GEN_ID(GEN_TCURRENTSET_RD, 0); if (tmp < new.RD) then tmp =
GEN_ID(GEN_TCURRENTSET_RD, new.RD-tmp); ENDEND^
SET TERM ; ^
please tell me how to do that . thx so much
Best Regards
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San
Francisco, CA to explore cutting-edge tech and listen to tech luminaries
present their vision of the future. This family event has something for
everyone, including kids. Get more information and register today.
http://sdm.link/attshape
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
