Recent

Author Topic: DBGrid filter component  (Read 5606 times)

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
DBGrid filter component
« on: July 30, 2017, 09:00:34 pm »
Hi guys, can anyone tell me a good component to filter a TDBGrid?

Thank you
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

taazz

  • Hero Member
  • *****
  • Posts: 5368
Re: DBGrid filter component
« Reply #1 on: July 30, 2017, 09:06:39 pm »
Hi guys, can anyone tell me a good component to filter a TDBGrid?

Thank you
visually? or you are looking for the dataset.filter and dataset.filtered properties?
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
Re: DBGrid filter component
« Reply #2 on: July 30, 2017, 09:11:32 pm »
Hi guys, can anyone tell me a good component to filter a TDBGrid?

Thank you
visually? or you are looking for the dataset.filter and dataset.filtered properties?

visually
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

taazz

  • Hero Member
  • *****
  • Posts: 5368
Re: DBGrid filter component
« Reply #3 on: July 30, 2017, 10:07:35 pm »
visually
try this one http://scalabium.com/smdbfltr.htm. It is for Delphi and I haven't looked closely yet, but I do not expect to much trouble porting over to lcl.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

PatBayford

  • Full Member
  • ***
  • Posts: 125
Re: DBGrid filter component
« Reply #4 on: August 02, 2017, 12:44:52 am »
I have successfully ported this component over to Lazarus, but sadly cannot get it to function properly, (i.e it does NOT filter my data), however, I only have access to SQLite3 tables, which may be the problem!
Code attached below.
Lazarus 1.8.0 FPC 3.0.2 SVN 56594 Windows 10 64bit (i386-win32-win32/win64)

majid.ebru

  • Hero Member
  • *****
  • Posts: 502
Re: DBGrid filter component
« Reply #5 on: August 09, 2017, 11:48:05 am »
Hi

how can i use it?
.
can you show or make a sample in Lazarus?
.
Thankyou

 

TinyPortal © 2005-2018