Using Checkbox as boolean in DataAssist

[fragop363190]

Ok i want to make a question. Haven't test it.

If you got a boolean column 0/1 and u put in DataAssist that column in e.g. search field as CheckBox (assuming ull use checkbox for insert and update ofc).

If the checkbox won't be selected will it pass value=0 or will it pass value=NULL ?
I suppose when selected it will pass value=1.

[Ray Borduin]

You should set the checkbox value to value="1". Then in DataAssist you set the data type to "checkbox 0,1" and it will do the rest.

Technically the form behaves as if the checkbox doesn't exist if it isn't checked, but you don't have to worry about that because dataassist takes care of it.