(SOLVED) DBGrid dlookup question

[xinyiman]

Hi guys, I created a lookup field in a dbgrid. It works fine, but if I have so many records in the lookup list I need to be able to filter it by pressing the keys. Does anyone tell me how to do it? The example contains a few lines, hypothesized instead of showing a list of 1000 articles in the lookup, so you can select the desired value by scrolling it with the mouse.

Anyone know how to help me? Thank you

[xinyiman]

No suggestion?

[taazz]

I usually do not filter my lookup fields, I make sure that they are sorted by the description field and I'm using the locate function to auto-select the first closest value in the dataset. I haven't looked at the posted code yet but in order for a filter to work you need to make sure that it is cleared when the master dataset is scrolled to a new record and the record packets are set to 0 forcing a "retrieve all" when open, otherwise the results will be sketchy at best.

[xinyiman]

@taazz: can you change my example using the locate? Because I can not get it to work. Thanks, it's very important to me

[taazz]

I'll se what I ca ndo later tonight at home.

[xinyiman]

Thanks so much

[xinyiman]

@taazz: news?

[taazz]

I didn't had much time yesterday, I only installed zeos data objects added more names and jobs to help in testing and the rest today. I will start by adding an external dblookupcombo and making it work there, after that I'll embed the same logic in the dbgrid editor. Sorry, it will take a bit longer than I planed.

[xinyiman]

She does nothing, look.
Appearance
Thanks so much

[taazz]

Find attached the first results. Is this sufficient or should I try to implement filtering as well?

[xinyiman]

Thank you taazz! Is perfect