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";<m...@lawinegevaar.nl>;
????????: 2016??7??3??(??????) ????5:23
??????: "For users and developers of the Firebird .NET
providers"<firebird-net-provider@lists.sourceforge.net>;
????: 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" <firebird-net-provider@lists.sourceforge.net>
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
