kevind
Posts: 251
|
| Posted: 03/12/2012, 10:22 AM |
|
MS Access project.
Checkbox field for Boolean data type or YESNO field
I have other fields on other forms that work without issue. This form and field just won't take an update through a checkbox. I dumped the checkbox, recreated it, created a new scratch page and form and copied and pasted in the checkbox (only field on form) from that form and it still didn't work.
I changed the type from chkbox to listbox to radiobutton - none worked. I compared the field's properties to other forms with YESNO field types and they are no different.
I finally had to settle for using a Textbox with format Y;N - this does update the database field and then retrieves the current value correctly. All other method would always show the value as True after attempting to update it to false.
Anyone have a fix for this time waster ?
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
 |
 |
tumby1974
Posts: 26
|
| Posted: 03/14/2012, 8:32 AM |
|
What do you have for the Checked Value and Unchecked Value in the Data tab for the checkbox?
|
|
|
|
kevind
Posts: 251
|
| Posted: 03/15/2012, 6:26 AM |
|
Quote tumby1974:
What do you have for the Checked Value and Unchecked Value in the Data tab for the checkbox?
I have tried 1,0 - true,false - y,n
I normally do not need to indicate anything.
I can create a brand new page and form with that field as a checkbox and it works fine.
I'm using a custom update because the form draws fields in from multiple tables, but this too is set up the way I normally do when it actually works.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
kevind
Posts: 251
|
| Posted: 09/26/2012, 8:59 AM |
|
finally figure it out - BUT NO FIX 
If I take a working form with a checkbox that has fields that update ONE table, then I create a Custom Update for the form using TABLE and let CCS pull in all the control fields - that is when the error occurs.
Once the form becomes a Custom Update by Table, the checkbox stops working - so this make me think the issue is with the Update statements in the ASP code that CCS is generating.
As soon as I delete the CUSTOM Update and let it update 'naturally', it starts working again.
A side note - if the value in the database is unchecked and I set up the Custom Table Update, the form IS able to update the field to True or 'yes' -- but, it cannot update it to False or 0 in the database.
I'm going to next investigate the SQL it is building before the update and see what is different.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
kevind
Posts: 251
|
| Posted: 09/26/2012, 9:14 AM |
|
SOLUTION !!! 
The problem was that a checkbox for a Boolean that is unchecked is treated by CCS as empty. So the setting in the Custom Update Table method that states:
If parameter is empty: needs to be set to the second option 'Use Value' and the value should match your database's (MS Access in my case) value for false, in my case 'false' is what I put in.
Problem solved after much head scratching.
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
tumby1974
Posts: 26
|
| Posted: 09/26/2012, 11:01 AM |
|
I'm glad you found the answer!
|
|
|
|
|
