How can I create a YES/NO column?

[michaaal]

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

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?

 

[Rob Meade]

...

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

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?

You haven't mentioned what type of database you are using (Access/SQL Server
etc), however, you could always add a 'bit' or 'char' datatype and give it a
size of 1, then all 1's might be Yes and 0's might be No - you could handle
this within the app.

Regards

Rob

 

[Aaron [SQL Server MVP]]

etc), however, you could always add a 'bit' or 'char' datatype and give it

a
size of 1, then all 1's might be Yes and 0's might be No

And if it's char(1), may as well be 'Y'/'N' or 'T'/'F' ...

 

[Rob Meade]

...

And if it's char(1), may as well be 'Y'/'N' or 'T'/'F' ...

aye, I should have mentioned that....thanks for the pick-up Aaron ;o)

Regards

Rob