I am using RemoteDB to retrieve data into a TxDataset and display in an FNC grid. I am trying to filter the data using the new TTMSFNCDataSetFilterDialog. I set the Dataset as the TxDataSet but no filter is ever applied and the grid data remains the same. How can this be accomplished ?
TXDataset does not implement Filter property. Anything there is ignored, for client-side filtering you should use OnFilterRecord event. I'm not sure if TTMSFNCDataSetFilterDialog allows filtering with the event, if it only uses Filter property then it's not supported.
Hello George,
In this blogpost you can read how to filter with the filter dialog in the TXDataSet with the OnFiterRecord event: TMS Software | Blog.
On the other hand you can also enable Advanced Filtering in the TMSFNCDataGrid and do the filtering on grid level.
Thanks Gjalt, I already used grid filtering, but I liked the new filter dialog. I'll try the OnFilterRecord event