CREATE TABLE syntax error...

10/09/2007, 17h48

CREATE TABLE Agents
(ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,
Name VARCHAR(255),
Supervisor INTEGER,
MasterCalendarVisible BOOLEAN default false)

I'm using this against an Access DB using JET driver... I keep getting
a syntax error which goes away when I remove the last line... Any
ideas whats wrong with it?

Thanks!

10/09/2007, 17h55

NEVERMIND!

Im an idiot... Just needed to swap BOOLEAN for BIT...

10/09/2007, 17h48	#1
bodyboarder20@gmail.com Messages: n/a Hébergeur:	CREATE TABLE syntax error... CREATE TABLE Agents (ID COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY, Name VARCHAR(255), Supervisor INTEGER, MasterCalendarVisible BOOLEAN default false) I'm using this against an Access DB using JET driver... I keep getting a syntax error which goes away when I remove the last line... Any ideas whats wrong with it? Thanks!

10/09/2007, 17h55	#2
bodyboarder20@gmail.com Messages: n/a Hébergeur:	Re: CREATE TABLE syntax error... NEVERMIND! Im an idiot... Just needed to swap BOOLEAN for BIT...

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email