whats wrong with this sql statement?

[ae_jester]

Hi what is wrong with this sql statement?

mySQLstring = "CREATE TABLE Reservations2002 ResNumber LONG CONSTRAINT myconstraint PRIMARY KEY, CustomerID LONG, ReservationDate DATETIME, FreeDay LONG, Status TEXT (50) );"
    mydb.Execute mySQLstring

The above code generates the following error....

"Sytax error in CREATE TABLE statement"

[Si_the_geek]

is this too obvious??

you have no bracket after the table name...

[ae_jester]

Warning to other programmers. Do not go to work on 4 hours sleep or you start to go blind!!!!

I'm an idiot!