Inserting Boolean values into a table

[Guest]

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

 

[Guest]

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