![]() |
От: | cse | |
Дата: | 10.07.13 20:20 | ||
Оценка: |
![]() |
От: | cse | |
Дата: | 10.07.13 21:09 | ||
Оценка: |
create table t1
(
id integer not null,
field1 varchar(20) not null
);
CREATE GENERATOR gen_t1_id;
SET GENERATOR gen_t1_id TO 0;
set term !! ;
CREATE TRIGGER T1_BI FOR T1
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
if (NEW.ID is NULL) then NEW.ID = GEN_ID(GEN_T1_ID, 1);
END!!
set term ; !!