Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 28 Mar 2024, 10:36

All times are UTC




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: 13 Aug 2022, 17:16 
Offline

Joined: 15 Mar 2021, 16:33
Posts: 37
Hi

How to search in all fields(vendorname/city/state/fax) in DbgridEh lookup vendor colums(MainDemo.exe ) Import/Exports example (see pict) .

Note:The example only search in vendorname field.

Best Regards


Attachments:
ehlib.jpg
ehlib.jpg [ 201.22 KiB | Viewed 821 times ]
Top
 Profile  
 
PostPosted: 15 Aug 2022, 04:26 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

You need to assign properties:
TColumnEh.DropDownBox.ListSource = NewDataSource (with NewDataSet)
TColumnEh.DropDownBox.ListSourceAutoFilter = True
TColumnEh.DropDownBox.ListSourceAutoFilterType = lsftContainsEh
TColumnEh.DropDownBox.ListSourceAutoFilterAllColumns = True


DropDownBox.ListSourceAutoFilter = True.
Enable filtering on typing (And search)

DropDownBox.ListSource
must refer to the DataSource which DataSource.DataSet a separate DataSet that will filter the data.

DropDownBox.ListSourceAutoFilterType = lsftContainsEh
To filter and search subtext inside field values

DropDownBox.ListSourceAutoFilterAllColumns
To filter and search in all columns of DropedDownWindow

TColumnEh.LimitTextToListValues
Set to False, to allow enter any text in the edit box that doesn't only start with text from display values.

Read also documetation:
"EhLib Users Guide.doc"
Section: Filtering data in drop-down lookup lists when typing

Look at the Demo project:
Demos\LookupCombo.LookupFilter

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 23 Aug 2022, 08:43 
Offline

Joined: 15 Mar 2021, 16:33
Posts: 37
Thank you. It is work but the search in all columns is slow any advice to be fast


Top
 Profile  
 
PostPosted: 25 Aug 2022, 12:35 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

Can you write on what volumes of data it is necessary to test the search in order to understand that the speed of the search is not enough for comfortable work?

How many records, how many columns?
Or perhaps you can send a Demo project.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 54 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group