interbase7.1+ibx的触发器问题
lu_zi 2004-04-15 10:01:09 在程序中,使用了触发器来完成其数值自动增加的功能,代码如下:
/* Table: MEMBER, Owner: SYSDBA */
CREATE TABLE "MEMBER"
(
"MEMBER_ID" INTEGER NOT NULL,
"MEMBER_NAME" VARCHAR(20) CHARACTER SET GB_2312 NOT NULL,
"MEMBER_REMARK" BLOB SUB_TYPE BLR SEGMENT SIZE 1024,
CONSTRAINT "PK_MEMBER" PRIMARY KEY ("MEMBER_ID")
);
SET TERM ^ ;
/* Triggers only will work for SQL triggers */
CREATE TRIGGER "MEMBER_BI" FOR "MEMBER"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.MEMBER_ID IS NULL) THEN
NEW.MEMBER_ID = GEN_ID(GEN_MEMBER_ID,1);
END
^
COMMIT WORK ^
SET TERM ;^
但是在使用IBTable时增加数据提示必须输入MEMBER_ID,怎么搞?