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
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