Subject | Why Tutorial Examples doesn't works |
---|---|
Author | gato2707 |
Post date | 2005-07-12T15:50:55Z |
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
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