cnjmorris
Oct 17th, 2004, 05:19 PM
How is the best way to have a form set/read the equivelant of yes/no in SQL CE.
I believe I can extend the checkbox to be a true/false type box. I believe I can further extend 4 of them to work as radio controls.
The problem I am facing is linking the check state of those boxes directly to a SQL Server CE 2.0 database. Since there is no yes/no or true/false data types.
I am thinking of using Integer and using values like 1 for yes, 2 for no, but of course this requires more work than simple yes/no values.
Is there a simple way of doing this I am not aware of and I am overlooking?
Thanks for any help or pointers.
I believe I can extend the checkbox to be a true/false type box. I believe I can further extend 4 of them to work as radio controls.
The problem I am facing is linking the check state of those boxes directly to a SQL Server CE 2.0 database. Since there is no yes/no or true/false data types.
I am thinking of using Integer and using values like 1 for yes, 2 for no, but of course this requires more work than simple yes/no values.
Is there a simple way of doing this I am not aware of and I am overlooking?
Thanks for any help or pointers.