C1TrueDBGrid with FilterBar enabled gives error when filtering

C1TrueDBGrid with FilterBar enabled gives error when filtering

Posted by: yammi900 on 27 September 2017, 8:37 pm EST

• 

  yammi900

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 8:37 pm EST

  I’m using the latest C1TrueDBGrid for Winforms in an EF6 Project targeting .Net 4.5 in conjunction with C1DataSource. Beside the problems with C1 template for generating entities I’m facing an issue C1TrueDBGrid when using the FilterBar together with the FilterDropdown and FilterMultiSelect properties set to true for a column (the rest remains set to default values).

  If I select a single value from the DropDown C1TrueDBGrid gives an error message “bad expression”, if I select multiple values it shows an “unbalaced parenthesis” error. Typing into the filter cell results in “bad expression” messages each time I type a character.

  If I disable the FilterBar, however, the FilterDropdown shows in the column header and filtering works as expected.

  What’s wrong? Who is to blame? C1TrueDBGrid or C1DataSource?

  Regards,

  Chris

• 

  arpit-jain

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 8:37 pm EST

  Hello,

  We could replicate the issue at our end. We have escalated this to the development team and will let you know as soon as there is any reply from them.

  Regards
  
  Arpit Jain

• 

  yammi900

  • Post Options:
  • Link
    Copy

  Posted 27 September 2017, 8:37 pm EST

  Thank you,

  Chris

• 

  Pragati.Kaushik

  

  • Post Options:
  • Link
    Copy

  Posted 27 November 2017, 4:56 am EST

  Hi,

  I am sorry but, C1DataSource doesn’t support filters with IN operator.

  ~Pragati