473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
4 4322
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Thomas Jerkins | last post by:
When I write a create table SQL statement I want to add some information about the column heading of each column. How does the exact syntax for the create table look like (which includes this column...
0
by: Guy Deprez | last post by:
Hi, i'm having a problem to create indexes. STEP 1 ----------- Connection is OK (you can find the string at the end of the message) Table ("Couleurs") creation is OK STEP 2. Index Creation
1
by: Not Me | last post by:
Hi, I'm sure this is a common problem.. to create a single field from a whole column, where each row would be separated by a comma. I can do this for a specified table, and column.. and I've...
7
by: Wolfgang Kreuzer | last post by:
Hello all, I have two tables - Projects and ProjectStruct Table Projects contains master records of the projects, ProjectStruct allows to define a project herarchie and contains the fields...
3
by: MrNobody | last post by:
I've read that the expression property for DataColumns is used to "Sets or retrieves the expresssion used to filter rows, calculate the values in a column, or create an aggregate column.". I...
3
by: shiranaomi | last post by:
I'm wondernig if it's possible to do the following: I'd like to average every 2 numeric values in a table as they appear sequentially ordered by their time stamps. I was thinking the only way to...
3
by: Robert Ludig | last post by:
I am fairly new to SQL and I am currently trying to create a SQL table (using Microsoft SQL) that has a recursive relationship, let me try to explain: I have a piece of Data let's call it "Item"...
27
by: max | last post by:
Hello, I am a newbye, and I'm trying to write a simple application. I have five tables with three columns; all tables are identical; I need to change some data in the first table and let VB...
2
by: miladhatam | last post by:
hi i know how can i create a table with sql command but i don't know how create a field with type integer ,autoNumber (auto increase) and Primary key Like id field in Access may you change...
2
by: lakuma | last post by:
Hi, I have a table called A (say) with columns called name, place, animal and thing. I would want to write an on insert trigger on this table, which would create a table with the name of the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.