Best way to have a Check Box feed an Integer Boolean

Classic Servoy
1

I am thinking that this should be easy … maybe I am missing something here …

My backend database table uses Integer (values are null, 0 or 1) with a preferred front-end Form write of 0 or 1 for false/true from the Check box.

I would prefer to use a Check Box (and I have a number of these fields) that takes the state of unchecked to 0 or checked to 1. Valuelists (with a value of 0 or 1) seem to mess around with the Check Box GUI a little too much.

Easy enough to do in code on a DataChange event but I keep thinking there must be a more elegant way to do this without ending up with a whole bunch of form level methods.

Global Method with an Eval()?

Or, is there a way to do this in 3.5 (rc5) using the Conversion tab (Data Providers. Column level)? I don’t know how the Conversion tab works yet (can’t figure it out …).

Is there an easy way to do this?

Thanks

Michael

2

Maybe I’m misunderstanding your post but if you simply put a check box on a form attached to an int field and WITHOUT valuelist you should get what you want: 1 for checked, 0 for unchecked and NULL for “never checked”.

3

Thanks Nicola - that’s all that was needed. Another case of me getting too complicated! :D