Inserting Boolean values into a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
No, treat them like you would numeric values. That is what they really are 0
= False and -1 = True
 
Back
Top