Question about Checkbox in the FNCGrid

I have the following query and would like the tmp2 column showing as a checkbox

SELECT id, (CASE WHEN tmp=5 THEN 1 ELSE 0 END) AS tmp2 FROM artikel
SELECT id, (CASE WHEN tmp=5 THEN 'true' ELSE 'false' END) AS tmp2 FROM artikel
Although I am able to show the checkboxes themselve the values aren't set according to the results of the query. Is this possible at all or am I doing something wrong. In that case can you give me an example how to fix this?
Best regards

Which field type is used?

tmp is a VarChar type field

If you configure the grid database adapter column to be a CheckBoxField and you set CheckTrue to the string value representing Boolean True you should be able to link it as a Boolean.

Somehow I’m doing something wrong or are overlooking something.
My grid shows this

Scherm­afbeelding 2024-05-15 om 10.44.58

When using either one of these

Columns.Items[13].ColumnType := ctCheckBox;
Adapter.Grid.Columns.Items[13].ColumnType:= ctCheckBox;

It shows a checkbox, so far so good

Scherm­afbeelding 2024-05-15 om 10.45.36

But where do I put the

with TMSFNCGrid do
if ((ARow > 0) and (ARow < FixedRows)) then Cells[13,ARow] := CheckTrue

In order to show the checkmarks?

Best regards

The CheckTrue and CheckFalse values that need to match the cell contents and evantually map on the checked value of the checkbox can be set at column level in the database adapter.