Boolean to Value for SQL

[ree32]

When I try to insert values from a boolean into SQL I keep getting this
error.

The name 'True' is not permitted in this context. Only constants,
expressions, or variables allowed here. Column names are not permitted

"INSERT INTO table (bitColName) VALUES ('" & boolValue & "')
Is there an easier way to convert the boolean value to 0 or 1 than
using the long approach of creating an integer and setting that to 0 or
1 depending on the boolean?

[Cor Ligthert [MVP]]

Ree,

Use parameters, have a look at the simple sample for this on our website.
There are as well two more extended samples.

http://www.windowsformsdatagridhelp....6-7139b8970071

Cor

[C-Services Holland b.v.]

re***@hotmail.com wrote:

When I try to insert values from a boolean into SQL I keep getting this
error.

The name 'True' is not permitted in this context. Only constants,
expressions, or variables allowed here. Column names are not permitted

"INSERT INTO table (bitColName) VALUES ('" & boolValue & "')
Is there an easier way to convert the boolean value to 0 or 1 than
using the long approach of creating an integer and setting that to 0 or
1 depending on the boolean?

"INSERT INTO table (bitColName) VALUES ('" & iif(boolValue,"1","0") & "')

[ree32]

Thanks I was hoping for simple solution in VB.net rather than the SQL.

C-Services Holland b.v. wrote:

"INSERT INTO table (bitColName) VALUES ('" & iif(boolValue,"1","0") & "')

[Stephany Young]

As an alternative you could use:

Math.Abs(CType(boolValue, Integer))
<re***@hotmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

Thanks I was hoping for simple solution in VB.net rather than the SQL.

C-Services Holland b.v. wrote:

"INSERT INTO table (bitColName) VALUES ('" & iif(boolValue,"1","0") & "')

[Bob]

Cor:

How does a date param pertain to BOOL field?

Bob

[ree32]

Thanks

Stephany Young wrote:

As an alternative you could use:

Math.Abs(CType(boolValue, Integer))