Add Boolean Column using DAO 1

[waytech2003]

I am using VB6 DAO 3.6 and need to add a new True/False field to an existing table.

I have used "ALTER TABLE" to add TEXT fields, but I can not figure out how to add a boolean field.

I have tried
==========================================================
db.Execute ("ALTER TABLE Customer ADD COLUMN [Test] Boolean")==========================================================

But I get an error #3292 "Syntax error in field definition"

How do I make a Boolean field?

 

[gmmastros]

db.Execute ("ALTER TABLE Customer ADD COLUMN [Test] [!]Bit[/!]")

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[waytech2003]

gmmastros

That worked perfectly. Thank you

 

[SmokinWrek]

If this is an Access database, you might try YesNo as your datatype.

Kevin

 

[waytech2003]

Kevin

Yes it is an Access database, and yes that works too.

 

[gmmastros]

I am more familiar with Microsoft SQL Server (where you have bit fields). I did run this against an Access database before posting, and it worked. Not all SQL that works on Access also works on SQL Server.

Thanks for the star.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom