[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 TCURRENTSET ACTIVE BEFORE INSERT POSITION 0 AS DECLARE 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); END END^ 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
Re: [Firebird-net-provider] some questions about Firebirsql
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 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
Re: [Firebird-net-provider] some questions about Firebirsql
You need to remove set term instructions, it is not actually part of the Firebird syntax. They are only used by query tools like ISQL and Flamerobin. So remove both set term instructions and the ^ after the final end and you should be able to execute the create trigger using the .net provider. Mark - Bericht beantwoorden - Van: "陈文欢" <9183...@qq.com> Aan: "firebird-net-provider" Onderwerp: [Firebird-net-provider] some questions about Firebirsql Datum: za, jul. 2, 2016 12:25 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 TCURRENTSET ACTIVE BEFORE INSERT POSITION 0 AS DECLARE 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); END END^ 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
[Firebird-net-provider] ?????? some questions about Firebirsql
hey,mark thx for your reply. i have already solve it. maybe some questions when i use the function of FBscript. anyway,thx a lot. Regards Chen -- -- ??: "Mark Rotteveel";; : 2016??7??3??(??) 5:23 ??: "For users and developers of the Firebird .NET providers"; : Re: [Firebird-net-provider]some questions about Firebirsql You need to remove set term instructions, it is not actually part of the Firebird syntax. They are only used by query tools like ISQL and Flamerobin. So remove both set term instructions and the ^ after the final end and you should be able to execute the create trigger using the .net provider. Mark - Bericht beantwoorden - Van: "??" <9183...@qq.com> Aan: "firebird-net-provider" Onderwerp: [Firebird-net-provider] some questions about Firebirsql Datum: za, jul. 2, 2016 12:25 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 TCURRENTSET ACTIVE BEFORE INSERT POSITION 0 AS DECLARE 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); END END^ 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