Subject | known token error but I don't know why!!! |
---|---|
Author | jacobswell4u |
Post date | 2008-06-04T01:25:05Z |
Hello, I'm a newbie of firebird and I just try to use it but got an
error but I don't know why.
the sql query is:
SQL> create table test(
CON> my_id varchar(255) character set none not null default '',
CON> au_menu varchar(20) character set none not null default '',
CON> au_auth char(1) check(value in ('r','w','d')) not null default '',
CON> primary key (mb_id,au_menu)
CON> );
The error code is:
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 2, column 48
-default
In my thinking is there any rule for default value?
Any help would be appreciated.
* parden me if there is any wrong english.
error but I don't know why.
the sql query is:
SQL> create table test(
CON> my_id varchar(255) character set none not null default '',
CON> au_menu varchar(20) character set none not null default '',
CON> au_auth char(1) check(value in ('r','w','d')) not null default '',
CON> primary key (mb_id,au_menu)
CON> );
The error code is:
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 2, column 48
-default
In my thinking is there any rule for default value?
Any help would be appreciated.
* parden me if there is any wrong english.