Wrong on filter call rDBGrid?

[Alejandro A.G.]

Im trying this nice components , i need a dbgrid with two main funcionalities, Short (columns) and Filter (search)

For simple proof, i put a rDBGrid and a rDBGridSorter, and looks it work fine... but not in every column!

It's sort a numeric column, but not other (same kind in DB), may be a limitation of the trial?

By the other side, i try to put some kind of "filter/search" Row inthe grid, without lucky.
Then i try to use ShowFilterDlg over the Grid, but only works in the FIRST column, no matter where column/cell i clicked (I use SelectRow=True)

Exists some kind (CRDBGrid) search/Filter permanent on top of the grid?

Tks!

By the way, i love this components when im trying and understaningd his power.

[Tomas Rosinsky]

Hello, thanks for trying of my components, I hope you will find it usefull.

Regarding sorting - data sorting is not functions of the dbgrid but dataset, my rDBGrid only catch click on title, set sorting properties of dataset according used rDBSorter and show sorting glyphs in the title row. Which fields support sorting depends on used dataset type, often used datasets (ADO, FireDac, UniDac...) supports sorting for all fields except graphics and memo. See my page http://www.rosinsky.cz/delphi/dbgrid_sorting.html for details or send me more details about your dataset type by email and I will try to help.

Regarding filter - my rDBGrid support funnel filter like in MSExcel, see example on http://www.rosinsky.cz/delphi/dbgrid.html. It allows to select any value or enter filter conditions directly from DBGrid. Another possibility is to use DBActions and Dialogs - rDBFilter again allows to add filter conditions. But there is not possibility to type filter condition directly to DBGrid. I will evaluate and try to add in the future.

I hope it helps

Tomas