tboss132
03-04-2005, 12:50 PM
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
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