InfoPath Dev

Have been using InfoPath 2007 for some time now, but cannot figure out how to get the value stored by a checkbox into my SQL database mapped back to the checkbox field.  I can get the checkbox to store data in the field on submit, but if I run a query thru the same form,  the value is not mapped back to the checkbox. What am I missing here?  I can get this to work for option buttons.

 Thanks!

Hello Welcome to the Forums,

You have to verify once check box properties as below,

1. Default state is cleared

2. Value when cleared : false

3. Value when checked: true

Same like above properties check for option button also. Is it both the values are same or not?

Hi, what I found was that to get it to work on my form, I had to make the responses map to "y" or "n" and have the field it maps to as a single character, otherwise, while it would allow me to check or uncheck a value, it would not display the value back as a check or uncheck when running a query from the form.   I could not find where this is documented anywhere.

Thanks again.

Hello,

Whichever you found solution is correct. We have to set one single character for Boolean variable in database. If you want you can set the value 1 for true and 0 for false.