Page 1 of 1
Lookupfield and Onfilterrecord Event
Posted: Tue 27 Sep 2011 18:57
by luis_augusto
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.
Posted: Fri 30 Sep 2011 06:40
by AndreyZ
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.
Posted: Wed 05 Oct 2011 19:39
by luis_augusto
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
Posted: Fri 07 Oct 2011 08:08
by AndreyZ
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.