Inserting Boolean values into a table

M

Mark

Do boolean variables need to be enclosed by special characters when inserting
into a table?

For instance "Chr$(34)" enclose a string variable and "Chr$(35)" enclose a
date variable.

For example:
strSQL = "Insert Into myTable Values (" & _
Chr$(34) & rst.Fields(0) & Chr$(34) & ", " & _
Chr$(35) & rst.Fields(1) & Chr$(35) & ")"

dbs.Execute strSQL


Thanks, Mark
 
K

Klatuu

No, treat them like you would numeric values. That is what they really are 0
= False and -1 = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top