Watch, Follow, &
Connect with Us
Public Report
Report From: Delphi-BCB/FireMonkey/Components    [ Add a report in this area ]  
Report #:  124600   Status: Resolved
TGrid with CheckColumn linked to TFDQuery BooleanField does not show checkbox
Project:  Delphi Build #:  20.0.15596.9843
Version:    20.0 Submitted By:   Pau Dominguez
Report Type:  Issue Date Reported:  5/7/2014 8:05:40 AM
Severity:    Infrequently encountered problem Last Updated: 11/27/2015 7:32:18 AM
Platform:    All platforms Internal Tracking #:   65184
Resolution: Fixed (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
TGrid with CheckColumn linked to TFDQuery BooleanField does not show checkbox
Steps to Reproduce:
1. Create a FireMonkey HD project.
2. Drop a TFDConnection and link to MySQL table with boolean fields.
3. Drop a TFdQuery and link to the table
4. Create persistent field for boolean column
5. Drop a TGrid
6. Use LiveBindings editor to link boolean field to a column
7. Use Column editor to set ColumnStyle to Checkcolumn.
8. Open TFDQuery.
Set column properties:
ColumnStyle = CheckColumn
CustomFormat = %s="True"

Tomohiro Takahashi at 5/7/2014 7:00:50 PM -
Could you please provide sample project(including sample table schema and data) to reproduce/confirm your issue?

Pau Dominguez at 5/9/2014 12:10:41 AM -
Sorry Tomohiro.
I do not have time to provide proyects to all issues.
I lost time in the workaround.
The mysql boolean field works well this checkboxes but not in grid's checkcolumn.
The workaround is to use the property customformat and set it to '%s="True"'

Cristian Hidasi at 3/14/2015 1:03:14 AM -
Unfortunatelly the IDrawableCell element not work when linked to dataSource.

You can test simply:
Create a Firemonkey HD form.
Put a TGrid to form.
Create a ClientDataSet.
Add a simple boolean field and create the dataset.
Bind this field to Grid and run it:

in the grid not see the check box, only if you edited.

I have tested some dataset but not work except only the TPrototypeBindSource.

Server Response from: ETNACODE01