CREATE GENERATOR-firebird

j

Et eksempel på hvordan det kan lade sig gøre:

CREATE GENERATOR my_gen;

CREATE TABLE test (
  id  INTEGER NOT NULL PRIMARY KEY,
  xxx VARCHAR(10)
);

...

INSERT INTO test (id, xxx) VALUES (gen_id(my_gen,1), 'aaa');
INSERT INTO test (id, xxx) VALUES (gen_id(my_gen,1), 'bbb');
INSERT INTO test (id, xxx) VALUES (gen_id(my_gen,1), 'ccc');
INSERT INTO test (id, xxx) VALUES (gen_id(my_gen,1), 'ddd');
INSERT INTO test (id, xxx) VALUES (gen_id(my_gen,1), 'eee');