[Firebird-net-provider] some questions about Firebirsql

[陈. <91...@qq...>]

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