Sean
|
| Posted: 06/02/2002, 5:09 PM |
|
I am able to set and clear checkboxes, but I can't get their current setting to display. Any ideas?
In the interim I switched to textboxes formated to only accept Yes/No. This works but is not nearly as convenient as using a checkbox.
|
|
|
 |
Nicole
|
| Posted: 06/03/2002, 4:59 AM |
|
Sean,
on Grid form just add Label field and select proper Format (showing value) and DBFormat (db boolean format).
But on Record form there seems to be a problem. What programming language do you use?
|
|
|
|
Brian Bermingham
|
| Posted: 06/03/2002, 7:43 AM |
|
Sean
I was having similar problems with checkboxes in CCS Beta 5 and Access 2000 where I could set and unset the checkboxes but they wouldn't display the value from the database.
Under the Properties Data tab for the checkbox the Checked value was 1 and the Unchecked value was 0.
All I had to do was change the values to -0 and -1 and everthing worked!
Hope this helps
Brisn
|
|
|
|
Nicole
|
| Posted: 06/03/2002, 7:49 AM |
|
Sean,
for Record form checkbox file settings are following (I also use Access db):
Data Type: boolean
Checked Value: true
Unchecked Value: false
|
|
|
|
Sean
|
| Posted: 06/03/2002, 6:07 PM |
|
The -1 -0 values did the trick. Not exactly obvious! Hopefully the good folks at codecharge will straighten out some of their datatype issues.
Thanks to all for the help!!!
Sean
|
|
|
|
CodeCharge
|
| Posted: 06/03/2002, 7:30 PM |
|
Hi Sean,
This doesn't appear to be a CodeCharge issue. At least not based on what I can find on the net.
See:
http://www.gotfusion.com/workbench/components.html
==================================================
Due to an ASP issue, boolean values in MS Access and Byte values in SQL server will always show –1 for true and 0 for false, regardless of what is stored in the database. These same databases will accept and select the same boolean values entered as –1 and 0.
==================================================
or:
http://webtechsig.org/tips/asp-tips.htm
==================================================
...Even though Access displays the field contents as a Yes or No, it stores the contents as True or False, (-1 and 0 respectively)...
==================================================
If you'd like to report valid issues, please feel free to submit it at http://support.codecharge.com/support_new.asp and we will be happy to look into resolving them.
Tonight is the last chance before the official release 
Konrad
|
|
|
|
