EhLib.Com https://forum.ehlib.com/en/ |
|
How to search in DbgridEh lookup(MainDemo.exe ) https://forum.ehlib.com/en/viewtopic.php?f=5&t=1169 |
Page 1 of 1 |
Author: | redsea71 [ 13 Aug 2022, 17:16 ] | ||
Post subject: | How to search in DbgridEh lookup(MainDemo.exe ) | ||
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
|
Author: | EhLibSupport [ 15 Aug 2022, 04:26 ] |
Post subject: | Re: How to search in DbgridEh lookup(MainDemo.exe ) |
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 |
Author: | redsea71 [ 23 Aug 2022, 08:43 ] |
Post subject: | Re: How to search in DbgridEh lookup(MainDemo.exe ) |
Thank you. It is work but the search in all columns is slow any advice to be fast |
Author: | EhLibSupport [ 25 Aug 2022, 12:35 ] |
Post subject: | Re: How to search in DbgridEh lookup(MainDemo.exe ) |
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. |
Page 1 of 1 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |