create table SQL statement

[thomasp]

I am attempting to create a table in an Access database using VB2005 beta 2.
I seem to be able to get it to work all except for adding a Boolean column.
The following statement works if I remove the ""POI BOL, " & _" line from
it. Will someone please tell me the snytax for adding a boolean column?

Thanks,

Thomas
AccessCommand.C ommandText = "CREATE TABLE NewUTAMS (" & _
"ID int identity, " & _
"DTG datetime, " & _
"Grid TEXT (10), " & _
"confGrid TEXT (10), " & _
"POI BOL, " & _
"confSource TEXT (50), " & _
"Weapon_Typ e TEXT (50), " & _
"Target_NO TEXT (4), " & _
"EastError INT, " & _
"NorthError INT, " & _
"CONSTRAINT PrimaryKey PRIMARY KEY (ID))"

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.c om<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

[thomasp]

I found my answer. I should have waited a couple more minutes before
posting.

"POI BIT, " & _ works, now if I can figure out how to make it dispay as a
checkbox in access.

Thanks,

Thomas

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.c om<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access

[Cor Ligthert [MVP]]

Thomas,

Although you found your answer, do I suggest you to look at the parameters,
a more describting way to use when you are used to it.

http://www.vb-tips.com/default.aspx?...3-eb8b44af0137

(We are maintanancing our website this week, so don't look at not yet
working new buttons etc this week).

I hope this helps,

Cor
<th*****@msala. net> schreef in bericht
news:43******** **************@ news.newsdemon. com...

I found my answer. I should have waited a couple more minutes before
posting.

"POI BIT, " & _ works, now if I can figure out how to make it dispay as a
checkbox in access.

Thanks,

Thomas

--
Posted via NewsDemon.com - Premium Uncensored Newsgroup Service
------->>>>>>http://www.NewsDemon.c om<<<<<<------
Unlimited Access, Anonymous Accounts, Uncensored Broadband Access