Recent

Author Topic: RXDBGrid filter bug?  (Read 2951 times)

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
RXDBGrid filter bug?
« on: September 27, 2017, 10:56:35 am »
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?
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
Re: RXDBGrid filter bug?
« Reply #1 on: September 27, 2017, 10:45:33 pm »
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?
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
Re: RXDBGrid filter bug?
« Reply #2 on: September 28, 2017, 08:19:04 am »
No idea?
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

jlopez

  • Newbie
  • Posts: 3
Re: RXDBGrid filter bug?
« Reply #3 on: October 28, 2017, 03:25:55 am »
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.

 

TinyPortal © 2005-2018