MrSandman666
Programmer
Hello everybody.
I'm trying to create a table in an Access database via SQL.
When I enter something like this, everything works fine:
CREATE TABLE tblExample (
id INTEGER PRIMARY KEY NOT NULL,
txtBla TEXT NOT NULL,
intFoo INTEGER NOT NULL
)
BUT when I enter this, I get a Syntax error.
CREATE TABLE tblExample (
id INTEGER PRIMARY KEY NOT NULL,
txtBla TEXT NOT NULL,
intFoo INTEGER NOT NULL DEFAULT 1
)
What am I doing wrong here? It should be possible to set a default value with Access, right?
Please help me with this one. I'm really stuck here.
Thanx in advance.
I'm trying to create a table in an Access database via SQL.
When I enter something like this, everything works fine:
CREATE TABLE tblExample (
id INTEGER PRIMARY KEY NOT NULL,
txtBla TEXT NOT NULL,
intFoo INTEGER NOT NULL
)
BUT when I enter this, I get a Syntax error.
CREATE TABLE tblExample (
id INTEGER PRIMARY KEY NOT NULL,
txtBla TEXT NOT NULL,
intFoo INTEGER NOT NULL DEFAULT 1
)
What am I doing wrong here? It should be possible to set a default value with Access, right?
Please help me with this one. I'm really stuck here.
Thanx in advance.