...

View Full Version : Datatype in MSAccess through SQL



tboss132
03-04-2005, 11:50 AM
Hi all,
I'm trying to create a new table in access using an SQL statemtent from within ASP.
The generated statement is


CREATE TABLE test (text1 char(255),date1 date,text2 char(20),text3 char(20), text4 bit)

I keep getting syntax error. When i remove the last variable and it's


CREATE TABLE test (text1 char(255),date1 date,text2 char(20),text3 char(20))

the table is created and there are no errors.
I'm trying to create a yes/no field. Is bit the correct datatype or is there another datatype i should use?
Thanks in anticipation

tboss132
03-04-2005, 12:06 PM
Hi guys, solved my own problem. I was using a reserved keyword somewhere. Thanks anyway...



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum