is TTMSFNCGrid Filtering broken ?

FNC TMS FNC UI Pack
1

Hello,

I'm trying to use Column filtering feature from the grid.
I'm so far not able to get it working. I'm only getting empy list as you can see in picture hereunder:

image
image707×389 20 KB

How to reproduce ?
Opining TMS FNC UI Pack\Demos\VCL\Grid\Database\ADO Lookup demo
Setting TMSFNCGRid.Options.Filtering:Dropdown to true

Environment

  • Delphi 11.2 with latest patch
  • Win32 environment
  • TMS FNC Grid Version 1.0.8.2

Am I missing something?

2

With an active dataset, filtering is not supported unfortunately. You need to call TMSFNCGridDataBaseAdapter.LoadAllDataAndDisconnect, so the data is stored in the grid, and then the filter will pick up the values.

3

Thank you.

As dataset is inactive, how can we send modification back to the dataset?

4

Afterwards, you will need to re-enable the dataset. Or alternatively, you will need to filter on the dataset instead.