Hi ,

I have a table which name "LEAVE" , it works in FB1.02 and ib7.0 ,but it doesn't
work in FB1.5,what's the problem, whether the "leave" is key word? the table
is as the follows. please help!

/* Table: LEAVE */

CREATE TABLE LEAVE (
LEAVEID integer not null,
LEAVE_DATE TIMESTAMP DEFAULT 'NOW' NOT NULL,
EMPLOYEEID integer not null,
LEAVETYPEID integer not null,
LEAVE_B TIMESTAMP DEFAULT 'NOW' NOT NULL,
LEAVE_E TIMESTAMP DEFAULT 'NOW' NOT NULL,
LEAVE_CANCEL TIMESTAMP,
CHECK_MAN varchar(20),
DESCRIPTION varchar(1000));



/* Check constraints definition */

ALTER TABLE LEAVE ADD CHECK (LEAVE_E > LEAVE_B);


/* Primary keys definition */

ALTER TABLE LEAVE ADD PRIMARY KEY (LEAVEID);




[Non-text portions of this message have been removed]