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
or
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
Anske
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
When using either one of these
AddCheckBoxColumn(13)
Columns.Items[13].ColumnType := ctCheckBox;
Adapter.Grid.Columns.Items[13].ColumnType:= ctCheckBox;
It shows a checkbox, so far so good
But where do I put the
with TMSFNCGrid do
begin
if ((ARow > 0) and (ARow < FixedRows)) then Cells[13,ARow] := CheckTrue
end;
In order to show the checkmarks?
Best regards
Anske
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.