By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
What type of database?

Ray at home

"michaaal" <re******@verizon.net> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl...
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?

Jul 19 '05 #2

P: n/a
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" <re******@verizon.net> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl...
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?

Jul 19 '05 #3

P: n/a
Sorry for the multi-posting. The database is an MS Access Database.
Help!

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:Oi**************@TK2MSFTNGP12.phx.gbl...
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" <re******@verizon.net> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl...
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?


Jul 19 '05 #4

P: n/a
strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20), yesno
boolean);"
conn.execute(strSQL)
--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm

"michaaal" <re******@verizon.net> wrote in message
news:OD**************@TK2MSFTNGP11.phx.gbl...
Sorry for the multi-posting. The database is an MS Access Database.
Help!

"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:Oi**************@TK2MSFTNGP12.phx.gbl...
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" <re******@verizon.net> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl...
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?




Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.