Lookupfield and Onfilterrecord Event

luis_augusto · Post by **luis_augusto** » Tue 27 Sep 2011 18:57

There is a problem when using a query filtered through an onfilterrecord event as the Lookupdataset in a lookupfield.
The result field is not retrieved (for use in a grid, for instance. It appears blank).
If I disable the filter or use the filtersql property then the lookup works.
This use to work in SDAC.

AndreyZ · Post by **AndreyZ** » Fri 30 Sep 2011 06:40

I cannot reproduce the problem. Please try composing a small sample to demonstrate the problem and send it to andreyz*devart*com, including a script to create and fill a table. Also please specify the following:
- the exact version of UniDAC. You can learn it from the About sheet of TUniConnection Editor;
- the exact version of your IDE.

luis_augusto · Post by **luis_augusto** » Wed 05 Oct 2011 19:39

Sorry for the delay.
I sent you a sample. If you have a way to prevent this to happen in the current version, please let me know, since I cannot wait until next release.
Thank you

AndreyZ · Post by **AndreyZ** » Fri 07 Oct 2011 08:08

We have investigated this question. You should remove filtration from your filtered query and use lookup field by two fields at once in the first query. I've sent you your example with needed corrections that demonstrates this approach.