5 Replies Latest reply on Mar 27, 2009 10:48 AM by Newsgroup_User

    Set CheckBox as [1,0] instead of true/false?

    EvolvedDSM Level 2
      Because boolean is not a data type of SQL 2000, I have to set any boolean columns to data type bit and use 1 and 0 to determine true and false.

      I have a new application that pulls data from my SQL db. the CheckBox.selected value recognizes 1 and 0 and will check appropriately when I select a record in my database. However, when I need to add or update a record, CheckBox.selected wants to output as true or false, which my column will not accept. How can I get CheckBox to output a 1 or 0?