Recent

Author Topic: DBGrid scrolling issue when TBufDataSet has filter set  (Read 715 times)

Jiří Huňáček

  • New Member
  • *
  • Posts: 28
DBGrid scrolling issue when TBufDataSet has filter set
« on: June 23, 2024, 11:29:01 am »
Hello,

I have a TBufDataSet that displays data from excel sheet. When the entire table is without a filter, the DBGrid scrolls fine for me. But as soon as I set the filter, the data is filtered, but the scrollbar does not go down smoothly, but jumps. It looks like it still keeps the total number of rows regardless of the filter.

I tried searching but couldn't find anything about the DBGrid scrolling and TBufDataSet connection.

That's why I'm asking for help here and thank you in advance.

George
« Last Edit: June 23, 2024, 11:45:27 am by Jiří Huňáček »
Best regards / mit freundlichen Grüßen / s pozdravem
Jiří Huňáček (George)

Lazarus v3.6 and FPC v3.2.2 on Windows 10 x64

jamie

  • Hero Member
  • *****
  • Posts: 6734
Re: DBGrid scrolling issue when TBufDataSet has filter set
« Reply #1 on: June 23, 2024, 03:47:54 pm »
In the DataSet, there is a OnFilterRecord which allows you to reject it.

I don't know if that will solve the problem because I am not a DB expert by any means.
The only true wisdom is knowing you know nothing

 

TinyPortal © 2005-2018