PHWinfo - Afficher un message

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, 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!