Results 1 to 5 of 5

Thread: SQL Update on Bit field (Resolved)

Threaded View

  1. #1

    Thread Starter
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    38,988

    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.
    Last edited by Shaggy Hiker; Oct 21st, 2004 at 01:59 PM.
    My usual boring signature: Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width