I did :
CREATE TABLE FINFILE (
nfile Varchar(30) NOT NULL PRIMARY KEY,
des60 Varchar(60) NOT NULL,
nfile_up Varchar(30) DEFAULT CURRENT_TIMESTAMP NOT NULL UNIQUE );

SET TERM !!;
CREATE TRIGGER INS_NFILE_UNIQUE FOR FINFILE
BEFORE INSERT AS
BEGIN
NEW.nfile_up = Upper(NEW.nfile);
END !!

1) Using IB_WISQL, inserting values only in first 2 fields I get an
error message 'Nfile_up is a required field'

2) in DSQL instruction:
Insert into Finfile (Nfile, Des60) Values ('File_Names','Tables
Names')
works properly

WHY Default Value doesn't work in IB_WIQL ?

A.Baldini