{"id":1490,"date":"2013-10-03T15:07:21","date_gmt":"2013-10-03T05:07:21","guid":{"rendered":"http:\/\/www.malcolmgroves.com\/blog\/?p=1490"},"modified":"2014-07-02T16:42:31","modified_gmt":"2014-07-02T06:42:31","slug":"livebindings-how-to-treat-an-integer-field-as-a-boolean","status":"publish","type":"post","link":"http:\/\/www.malcolmgroves.com\/blog\/?p=1490","title":{"rendered":"LiveBindings : How to treat an Integer field as a Boolean?"},"content":{"rendered":"

I had a question recently from someone, and it seemed a common enough requirement that I thought the solution might be worth sharing.<\/p>\n

Let’s say you’ve got a database that has an Integer column which is really used as a Boolean. Zero for False, One for True. Further, for whatever reason, you can’t change the DB structure. How do you display this column to the end user as a boolean, so that they can use a Checkbox column in a grid, a TSwitch control, or similar to edit it?<\/p>\n

\"LiveBindingsIntegerAsBoolean3\"
\nNote, this could also apply to binding from something other than a<\/span><\/p>\n

database, such as a list of objects (see my post\u00a0TAdapterBindSource and binding to Objects<\/a>), but the solution applies anyway.<\/p>\n

You could of course do this at the dataset field level, using the TField.OnGetText<\/a>\u00a0and TField.OnSetText<\/a>\u00a0fields to convert the values back and forth, but let’s also look at what options the LiveBinding framework gives us.<\/p>\n

I actually covered the key parts of the solution in my post LiveBindings in XE3: Formatting your Fields<\/a>. In that post I used the CustomFormat and CustomParse expression in my links to add Currency formatting before displaying a field, and subsequently remove the Currency formatting on the way back to the field. We can use the same technique to actually change the datatype back and forth.<\/p>\n

If you have a look at the sample code<\/a>, I’ve got a ClientDataset with one field of type TSmallIntField, which I’ve imaginatively titled IntegerField. That is hooked up through a TBindSourceDB<\/a> to a TGrid<\/a>. The TLinkGridToDataSource<\/a> that is connecting the data to the TGrid has two columns. In the first I want to display the field as a Boolean, using a checkbox column, so I set its ColumnStyle<\/a> property to CheckColumn. In the second I’ll display the raw Integer value from the field so I leave the Column properties as default.<\/p>\n

 <\/p>\n

\"LiveBindingsIntegerAsBoolean1\"<\/p>\n

The bindings are pretty straight forward, but note the two columns are both bound to the one field.<\/p>\n

We still need to set up the logic to convert between the Integer and Boolean.\u00a0If we go back to the same column where we set the ColumnStyle to CheckColumn, we can use expressions in the CustomFormat and CustomParse properties to alter the value on the way from the field to the column (CustomFormat) and on the way back from the column to the field (CustomParse). In the screenshot below you can see the expressions I’ve used.<\/p>\n

\"LiveBindingsIntegerAsBoolean2\"<\/p>\n

In both cases, %s represents the value prior to any manipulation. I think the expressions are relatively straightforward, although perhaps the IfThen statement needs explanation. It tests whether the value of %s is True. If it is, it sets the field value to 1, otherwise it sets it to 0.<\/p>\n

 <\/p>\n

A few things to note:<\/p>\n