RXDBGrid filter bug?
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2017-09-27 08:56

Hi guys, I would have a question about the RXComponents. Specifically,
the RXDBGrid. It works fine, only when I try to filter a fklookup
field does not work. Probably because it filters on the key field with
the field value displayed. Does anyone know how to solve it?

----------------------------------------------------------------------
xinyiman · 2017-09-27 20:45

I did an example to replicate the problem. If you start the example
you have to press the button1 button. You will see that two columns
are added to the DBGrid3 (which is a TRXDBGrid). Then try using the
filters. You will see that column 0 and column 1 work well, while
column 2 and column 3 will not work.

Do you know how to solve me?

----------------------------------------------------------------------
xinyiman · 2017-09-28 06:19

No idea?

----------------------------------------------------------------------
jlopez · 2017-10-28 01:25

This limitation is not from RxDBGRid, if you try to filter with
LookupFields with Zeos components will get the same result.
I did some changes to rxdbgrid unit to avoid this problem and it
worked for my project. I hope this modifications work for you.
There is one disadvantage, keys are not sorted, but for my project
this was not a limitation.