YEAR is a reserved word. You must replace it with another word in 3
places in your SQL statement.

--- In firebird-support@yahoogroups.com, "gato2707" <gato2707@y...> wrote:
> Hi everybody.
>
> I'm new using Firebird, I'm trying to upgrade an application from
> FlashFiler to Firebird. I have the tutorials of Interbase 5.0 and 6.5,
> but when I try to follow the instructions, Firebird report and error
> 104 "invalid token in
> line 2 char 1 in the this code:
>
> CREATE TABLE PROJ_DEPT_BUDGET (
> year INTEGER NOT NULL CHECK (YEAR >= 1993),
> proj_id PROJNO NOT NULL,
> dept_no DEPTNO NOT NULL,
> quart_head_cnt INTEGER [4],
> projected_budget BUDGET,
>
> PRIMARY KEY (year, proj_id, dept_no),
> FOREIGN KEY (dept_no) REFERENCES department (dept_no),
> FOREIGN KEY (proj_id) REFERENCES project (proj_id));
> COMMIT;
>
> I changed the token "year" to any other word like (vyear, annio etc)
> but the
> error persist.
> I used ISQL, IBEasy and EMS Manager with same results, and there aren't
> difference if I type or Copy and Paste it. Any idea?
>
> Regards