Subject Why Tutorial Examples doesn't works
Author gato2707
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