https://bugs.freedesktop.org/show_bug.cgi?id=72783
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #2 from Lionel Elie Mamane <[email protected]> --- The "SET TERM" is a specificity of isql, FlameRobin, etc which is not necessary in LibreOffice. See http://www.firebirdfaq.org/faq78/ . I did the following in LibreOffice, worked for me: STEP 1: execute this statement in Tools/SQL create table t1 ( id integer not null, field1 varchar(20) not null ) STEP 2: execute this statement in Tools/SQL CREATE GENERATOR gen_t1_id STEP 3: execute this statement in Tools/SQL SET GENERATOR gen_t1_id TO 0 STEP 4: execute this statement in Tools/SQL 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 -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
