rDBGrid_is dblookupcombo, is it posible filter lookup dataset on entered keys

[enver penjo]

In  examples there is two queries:

qLookupProducts and aqSuppliers

and when we click on supplier column we can select supplier data aqSupplier.

When we click we on list program will search aqSuppliers to find searched supplier by our search.

Can we filter aqSupplierwith with that search substring?

for example if press some substring 'in'

program will filter aqSupplier with suppliers which have 'in' in its name.

[Tomas Rosinsky]

Hi, filtering of values in the lookup dropdown list is possible. Just set OptionsEx2.Editors. AllowLookupFilter = true.

property AllowLookupFilter: boolean read FAllowLookupFilter write FAllowLookupFilter default false;
allow filtering of dropdown list for the lookup fields

See also https://rosinsky.cz/delphi/doc_comp/rDBGrid.TOptionsEditors.html for other possible setting.

Regards

Tomas

Dne pátek 10. února 2023 v 16:37:07 UTC+1 uživatel penj...@gmail.com napsal:

[enver penjo]

It does not work s the my test app!