https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/3794.aspxFri, 05 Jan 2007 05:40:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3794jthrasher0https://www.infopathdev.com:443/forums/thread/3794.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3794The error is displayed when modifying the properties on the check box.<br /><br />When I add the check boxes to the form and link them to a field in the database that is already set to a binary, the data type is automatically sent to simpleType and the default values are blank. If I leave them blank, then the database show null for any submitted data whether checked or unchecked. If I try to modify the properties then it requires me to fill in the default values, which it won't let me enter 1 or 0.https://www.infopathdev.com:443/forums/thread/3793.aspxFri, 05 Jan 2007 04:43:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3793Matt Faus0https://www.infopathdev.com:443/forums/thread/3793.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3793Hi Jason and welcome to the forums!<br /><br />Are you seeing this error from the InfoPath Designer or when you submit? In my experience you don't need to change the checkboxes to 0/1 as long as the SQL data type is 'bit'. If you insert the value of 'true' into a bit field the database should convert that to the 0/1 that you are looking for. Have you tried just leaving everything at default?<br /><br />Also, what database server are you submitting to?https://www.infopathdev.com:443/forums/thread/1778.aspxFri, 05 Jan 2007 02:33:10 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1778jthrasher0https://www.infopathdev.com:443/forums/thread/1778.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1778I'm having a bit of trouble submitting data to a SQL database and am hoping you might be able to help. I have created a SQL database that has an assortment of binary columns which I want to relate to check boxes on the form. I would like a check to insert a "1" into the database, and an uncheck to insert a "0". Now, when I create my form connected to the SQL database it changes the data type to "simpleType" and when I set "value when cleared" to "0" and "value when checked" to "1" i get the error "the default value must match the data type. Change the value or the type." Since this field came from a database, it doesn't let me change the type so I'm confused.<br /><br />Jason