楚
楚辞
Unregistered / Unconfirmed
GUEST, unregistred user!
朋友们好!本人是一个菜鸟现在学做数据库。我用的是delphi的interbase中的IBConsole.
当我登录完服务器后,打开TOOL菜单利用interactive sql 建立数据表可是当我建完后
却提示我我应该如何办?谢谢!!!
SQL error code = -104错误请问这是怎么回事?Token unknown - line 1, char 0
SQL
Statement: SQL Statement
/* Table: PERSON, Owner: MISDBA */
CREATE TABLE PERSON (ID CHAR(6) NOT NULL,
PASSWD CHAR(20) NOT NULL,
AUTHORITY CHAR(1) DEFAULT '0',
NAME VARCHAR(10),
SEX CHAR(1) DEFAULT 'M' NOT NULL,
BIRTHDAY TIMESTAMP,
DEPARTMENT CHAR(3),
JOB CHAR(3),
EDU_LEVEL CHAR(1),
SPECIALTY VARCHAR(20),
ADDRESS VARCHAR(50),
TEL VARCHAR(20),
EMAIL VARCHAR(50),
STATE CHAR(1) DEFAULT 'T',
REMARK VARCHAR(4000),
CONSTRAINT PERSON_ID PRIMARY KEY (ID))
还有有时提示No active connection
Statement: SQL Statement
/* Table: PERSON, Owner: MISDBA */
CREATE TABLE PERSON (ID CHAR(6) NOT NULL,
PASSWD CHAR(20) NOT NULL,
AUTHORITY CHAR(1) DEFAULT '0',
NAME VARCHAR(10),
SEX CHAR(1) DEFAULT 'M' NOT NULL,
BIRTHDAY TIMESTAMP,
DEPARTMENT CHAR(3),
JOB CHAR(3),
EDU_LEVEL CHAR(1),
SPECIALTY VARCHAR(20),
ADDRESS VARCHAR(50),
TEL VARCHAR(20),
EMAIL VARCHAR(50),
STATE CHAR(1) DEFAULT 'T',
REMARK VARCHAR(4000),
CONSTRAINT PERSON_ID PRIMARY KEY (ID))
我该如何办!?
请大家帮着看看。顺便送上50分。
当我登录完服务器后,打开TOOL菜单利用interactive sql 建立数据表可是当我建完后
却提示我我应该如何办?谢谢!!!
SQL error code = -104错误请问这是怎么回事?Token unknown - line 1, char 0
SQL
Statement: SQL Statement
/* Table: PERSON, Owner: MISDBA */
CREATE TABLE PERSON (ID CHAR(6) NOT NULL,
PASSWD CHAR(20) NOT NULL,
AUTHORITY CHAR(1) DEFAULT '0',
NAME VARCHAR(10),
SEX CHAR(1) DEFAULT 'M' NOT NULL,
BIRTHDAY TIMESTAMP,
DEPARTMENT CHAR(3),
JOB CHAR(3),
EDU_LEVEL CHAR(1),
SPECIALTY VARCHAR(20),
ADDRESS VARCHAR(50),
TEL VARCHAR(20),
EMAIL VARCHAR(50),
STATE CHAR(1) DEFAULT 'T',
REMARK VARCHAR(4000),
CONSTRAINT PERSON_ID PRIMARY KEY (ID))
还有有时提示No active connection
Statement: SQL Statement
/* Table: PERSON, Owner: MISDBA */
CREATE TABLE PERSON (ID CHAR(6) NOT NULL,
PASSWD CHAR(20) NOT NULL,
AUTHORITY CHAR(1) DEFAULT '0',
NAME VARCHAR(10),
SEX CHAR(1) DEFAULT 'M' NOT NULL,
BIRTHDAY TIMESTAMP,
DEPARTMENT CHAR(3),
JOB CHAR(3),
EDU_LEVEL CHAR(1),
SPECIALTY VARCHAR(20),
ADDRESS VARCHAR(50),
TEL VARCHAR(20),
EMAIL VARCHAR(50),
STATE CHAR(1) DEFAULT 'T',
REMARK VARCHAR(4000),
CONSTRAINT PERSON_ID PRIMARY KEY (ID))
我该如何办!?
请大家帮着看看。顺便送上50分。