How can I create a YES/NO column in my table?

[michaaal]

I use this code to create a table dynamically...

strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
conn.execute(strSQL)


This will create two text columns. How can I create some YES/NO columns
instead of TEXT columns?

 

[Ray at]

What type of database?

Ray at home

 

[Ray at]

Please do not multipost. This post was quite appropriate in the .db group,
and there is no reason to also post it here. See here for more info:
http://www.aspfaq.com/etiquette.asp?id=5003

Ray at home

 

[michaaal]

Sorry for the multi-posting. The database is an MS Access Database.
Help!

 

[Egbert Nierop \(MVP for IIS\)]

strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20), yesno
boolean);"
conn.execute(strSQL)