Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    I've got an Access database linked to sql tables. There is a checkbox named [OT] that has null values that I want marked as False. I'm trying to do an update so that all null fields are marked as false. No matter what I enter as the "new value" in the field to update in the query, I get an error. What is the correct syntax to do this in SQL?

    Thanks!
    Leesha

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Quote Originally Posted by Leesha View Post
    Hi,

    I've got an Access database linked to sql tables. There is a checkbox named [OT] that has null values that I want marked as False. I'm trying to do an update so that all null fields are marked as false. No matter what I enter as the "new value" in the field to update in the query, I get an error. What is the correct syntax to do this in SQL?

    Thanks!
    Leesha
    What is the error?

    What is the SQL of the query?

    Is this field a new field in the SQL table? Is it a bit field? If so, you need to run the update query (I presume that's what you are doing) in SQL Server and not in Access.

    You will also have to set the default to 0 (zero) in Sql Server table design.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by patt View Post
    >>You will also have to set the default to 0 (zero) in Sql Server table design.

    Thanks Pat! This is the info I needed. The zero was the key!!!

    Leesha

Posting Permissions

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