Re: [Firebird-net-provider] some questions about Firebirsql

[stevyn d. <sr...@ya...>]

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: 陈文欢 <91...@qq...>
 To: firebird-net-provider <fir...@li...> 
 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
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider