Newbie Questions

Re: How to get checkbox to return database value on query?

Shiva — Wed, 31 Dec 2008 11:38:39 GMT

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.

Re: How to get checkbox to return database value on query?

flattenedfrog — Tue, 30 Dec 2008 18:02:14 GMT

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.

Re: How to get checkbox to return database value on query?

Shiva — Wed, 29 Oct 2008 13:26:16 GMT

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?

How to get checkbox to return database value on query?

flattenedfrog — Wed, 29 Oct 2008 12:24:24 GMT

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!