Ask a Question related to ASP Database, Design and Development.
-
michaaal #1
How do 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?
michaaal Guest
-
different column boarders within a table
It is easy to change the thicknesses of all columns and rows in a table but how to change the thickness of some of the columns and only the vertical... -
Getting the column from a table cell
Hello everyone, Is it possible (and if so, how) to obtain a reference to the column given a table cell for a datagrid? Zahid -
add column to table with sql
Does anyone know the SQL syntax to add a column to an existing Access table? -
How can I create a YES/NO column?
I use this code to dynamically create a column in a table... strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"... -
How to create a table with dynamic table name
<html><div style='background-color:'><DIV> <DIV class=Section1> <P class=MsoNormal style="mso-layout-grid-align: none"><FONT face="Times New Roman"... -
Ray at #2 Re: How do I create a YES/NO column in my table?
What database?
Ray at home
"michaaal" <res0gyio@verizon.net> wrote in message
news:Or$lXZkYEHA.1356@TK2MSFTNGP09.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?
>
>
Ray at Guest
-
Aaron [SQL Server MVP] #3 Re: How do I create a YES/NO column in my table?
Depends on the database. Does the database you're using have documentation
on the CREATE TABLE command?
--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)
"michaaal" <res0gyio@verizon.net> wrote in message
news:Or$lXZkYEHA.1356@TK2MSFTNGP09.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?
>
>
Aaron [SQL Server MVP] Guest
-
michaaal #4 Re: How do I create a YES/NO column in my table?
> What database?
Sorry....it is an MSAccess database
michaaal Guest
-
Ray at #5 Re: How do I create a YES/NO column in my table?
strSQL = "CREATE TABLE TableName (Firstname TEXT(30), Lastname TEXT(20),
SomeYesNo BIT)"
Ray at home
> I use this code to create a table dynamically..."michaaal" <res0gyio@verizon.net> wrote in message> strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
> conn.execute(strSQL)
news:OfwTNBlYEHA.712@TK2MSFTNGP11.phx.gbl...>> > What database?
> Sorry....it is an MSAccess database
>
>
Ray at Guest
-
michaaal #6 Re: How do I create a YES/NO column in my table?
Thanks Ray, it worked great.
"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:ekLgjJlYEHA.1224@TK2MSFTNGP09.phx.gbl...> strSQL = "CREATE TABLE TableName (Firstname TEXT(30), Lastname TEXT(20),
> SomeYesNo BIT)"
>
> Ray at home
>
>>> > I use this code to create a table dynamically...>> > strSQL = "CREATE TABLE (FirstName TEXT(30), LastName TEXT(20));"
> > conn.execute(strSQL)
> "michaaal" <res0gyio@verizon.net> wrote in message
> news:OfwTNBlYEHA.712@TK2MSFTNGP11.phx.gbl...>> >> > > What database?
> > Sorry....it is an MSAccess database
> >
> >
>
michaaal Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
