With IB 6 I have this situation
table : FINFILE (
NFILE VARCHAR(30) NOT NULL,
DES60 VARCHAR(60) NOT NULL,
NFILE_UP VARCHAR(30) DEFAULT CURRENT_TIMESTAMP NOT NULL,
PRIMARY KEY (NFILE),
UNIQUE (NFILE_UP));

CREATE TRIGGER INS_NFILE_UNIQUE FOR FINFILE
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
NEW.nfile_up = Upper(NEW.nfile);
END

I am at 3.6.Dg and use above table with TIBOTable ,TwwDataSource and
TwwDBGrid. The grid has only 2 fileds (NFILE , DES60)

I want let Db fill NFILE_UP but I receive the exception from
IBA_Dataset.IMP : 'NFILE_UP is a required field'

I tried following alternative steps :
1) Not describe any field with table
2) include in table all fields except NFILE_UP
3) include all fields and define NFILE_UP required.False in
TstringFields

I always get exception.

How can do it ?
Using pure SQL I can insert a record with nodata in NFILE_UP.

Thanks.
Adalberto Baldini