InfoPower Grid - How to add multiple multi-select checkboxes from a query result

Follow

Comments

2 comments

  • Wayne Hartley

    Hi Roy, I tried your solution, But I still seem to be missing something.

    SELECT TransID, CAST(0 AS BIT) AS RECALC, C.CUSTFSTNAME + ' ' + C.CUSTLSTNAME AS CUSTNAME FROM TABLE1 LEFT JOIN TABLE2.

    I combined the "Selected" Boolean field (as the first Check box). Is this the way you tested it? 
    Or did you use 2 extra fields in the query and exclude the "Selected" Boolean field?

    What datatype did you specify in your select statement?

    Also this is on Infopower4000VCL6 and BDE 5.2. (in the process of converting the project)

    1
    Comment actions Permalink
  • Roy Woll

    In my case I have the following query in TFDQuery


    select 0 as cb1, 0 as cb2, * from fdcustomer


    I made the query editable by setting cachedupdates to true. I then right-clicked the tfdquery to bring up the tfields editor. I added all the fields and made the cb1 and cb2 fields readonly to false. I then dbl-clicked the grid and in the cb1 and cb2 column's I configured the control type as checkboxes. I made the true value 1 and the false value 0 as they are tlargeint in my tfdquery. I did not use the selected checkbox feature built into the grid.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk