CREATE TABLE TBL_TEST_UPD
(
  ID INTEGER NOT NULL,
  STR_FLD VARCHAR(100),
  INT_FLD INTEGER,
  CURR_FLD NUMERIC(15,4),
  DATE_FLD TIMESTAMP DEFAULT current_timestamp,
  CONSTRAINT PK_TBL_TEST_UPD PRIMARY KEY (ID)
  USING INDEX PK_TBL_TEST_UPD_IDX
);

GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
 ON TBL_TEST_UPD TO  SYSDBA WITH GRANT OPTION;

SET TERM ^ ;
CREATE TRIGGER TBL_TEST_UPD_BI FOR TBL_TEST_UPD ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.ID IS NULL) THEN
    NEW.ID = GEN_ID(GEN_TBL_TEST_UPD_ID,1);
END^
SET TERM ; ^

leyba@debian93:~$ isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:/home/leyba/development/dbase/TEST_TREE.FDB' user sysdba password 'cooladmin';
Database: 'localhost:/home/leyba/development/dbase/TEST_TREE.FDB', User: SYSDBA
SQL> show db;
Database: localhost:/home/leyba/development/dbase/TEST_TREE.FDB
        Owner: SYSDBA                         
PAGE_SIZE 16384
Number of DB pages allocated = 3062
Number of DB pages used = 344
Number of DB pages free = 2718
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 8247
Transaction - oldest active = 8248
Transaction - oldest snapshot = 8248
Transaction - Next = 8252
ODS = 12.0
Database not encrypted
Default Character set: UTF8
SQL> show version;
ISQL Version: LI-V3.0.2.32703 Firebird 3.0
Server version:
Firebird/Linux/Intel/i386 (access method), version "LI-V3.0.2.32703 Firebird 3.0"
Firebird/Linux/Intel/i386 (remote server), version "LI-V3.0.2.32703 Firebird 3.0/tcp (debian93)/P15:C"
Firebird/Linux/Intel/i386 (remote interface), version "LI-V3.0.2.32703 Firebird 3.0/tcp (debian93)/P15:C"
on disk structure version 12.0
SQL> show users;
Users in the database
  2 #SYSDBA   
SQL> INSERT INTO TBL_TEST_UPD (STR_FLD, INT_FLD, CURR_FLD, DATE_FLD) VALUES ('STR_FLD', 222, 111.11, CURRENT_TIMESTAMP);
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
-At trigger 'TBL_TEST_UPD_BI' line: 6, col: 5
SQL> quit;
leyba@debian93:~$ 

leyba@debian93:~$ isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost:/home/leyba/development/dbase/TEST_TREE.FDB' user sysdba password 'cooladmin';
Database: 'localhost:/home/leyba/development/dbase/TEST_TREE.FDB', User: SYSDBA
SQL> INSERT INTO TBL_TEST_UPD (STR_FLD, INT_FLD, CURR_FLD, DATE_FLD) VALUES ('STR_FLD', 222, 111.11, CURRENT_TIMESTAMP);
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range
-At trigger 'TBL_TEST_UPD_BI' line: 6, col: 5
SQL> SELECT GEN_ID(GEN_TBL_TEST_UPD_ID, 0) FROM RDB$DATABASE;

               GEN_ID 
===================== 
         206158430233 

SQL> ALTER SEQUENCE GEN_TBL_TEST_UPD_ID RESTART WITH 0;
SQL> commit;
SQL> SELECT GEN_ID(GEN_TBL_TEST_UPD_ID, 0) FROM RDB$DATABASE;

               GEN_ID 
===================== 
                    0 

SQL> INSERT INTO TBL_TEST_UPD (STR_FLD, INT_FLD, CURR_FLD, DATE_FLD) VALUES ('STR_FLD', 222, 111.11, CURRENT_TIMESTAMP);
SQL> commit;
SQL> quit;
leyba@debian93:~$ 

C:\Users\leyba>cd /d d:\Portable_program\Firebird_server\Firebird_3_0_2\

d:\Portable_program\Firebird_server\Firebird_3_0_2>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'localhost/3302:d:\Archive\code_source\Threads\db\TEST_TREE.FDB' us
er sysdba password 'cooladmin';
Database: 'localhost/3302:d:\Archive\code_source\Threads\db\TEST_TREE.FDB', User
: SYSDBA
SQL> show db;
Database: localhost/3302:d:\Archive\code_source\Threads\db\TEST_TREE.FDB
        Owner: SYSDBA
PAGE_SIZE 16384
Number of DB pages allocated = 3062
Number of DB pages used = 345
Number of DB pages free = 2717
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 8252
Transaction - oldest active = 8253
Transaction - oldest snapshot = 8253
Transaction - Next = 8257
ODS = 12.0
Database not encrypted
Default Character set: UTF8
SQL> show version;
ISQL Version: WI-V3.0.2.32703 Firebird 3.0
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.2.32703 Firebird 3
.0"
Firebird/Windows/Intel/i386 (remote server), version "WI-V3.0.2.32703 Firebird 3
.0/tcp (leyba-pc)/P15:C"
Firebird/Windows/Intel/i386 (remote interface), version "WI-V3.0.2.32703 Firebir
d 3.0/tcp (leyba-pc)/P15:C"
on disk structure version 12.0
SQL> INSERT INTO TBL_TEST_UPD (STR_FLD, INT_FLD, CURR_FLD, DATE_FLD) VALUES ('ST
R_FLD', 222, 111.11, CURRENT_TIMESTAMP);
SQL> commit;
SQL> quit;
d:\Portable_program\Firebird_server\Firebird_3_0_2>