When you use DEFAULT on a column or domain that only applies if the column
is not included in the INSERT statement. In your case, you obviously are
including it so the DEFAULT on the server is not a part of things.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <finman@...>
To: <IBObjects@egroups.com>
Sent: Monday, January 08, 2001 1:38 AM
Subject: [IBO] Default Value - IB_WISQL


> 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
>
>
>
>
>
>