SQL Update on Bit field (Resolved)
I'm having a strange problem with an update query. I have an update line that includes a set statement like this:
SET Injected = " & injected & "
The column Injected is a bit field, and the variable injected is a boolean. In this query, I get an error saying the column name is invalid. I assume that I have to enclose the variable in some kind of punctuation, but I can't figure out what.
I was able to work around it by interpreting the boolean as an integer (1/0) which works fine when put into the statement.
I assume this is simple, but I haven't done it before, and haven't seen any usefull reference for it.