Current filter:
                                You should refresh the page.
                                  • Hi,
                                    when a DataSet used in TcxDBLookupComboBox as ListSource is filtered, the lookups are affected by this filtering. The standard VCL-TDBLookupComboBox does not have this behavior. Please see attached sample-project where entering in the lkp2-control the lookup-datasource is filtered. Try with record-ID=2, in the "standard"-lookup you see still the value, whereas in the devexpress-lookup the value is toggled until you exit the lkp2-control.
                                    It would be enough to have some property to instruct the lookup to not be updated if the underlying Listsource is changed.
                                    best regards
                                    Toni
                                    Steps to Reproduce:
                                    the step showing the problem are:
                                    - in the grid above select the record with ID=2 and you will see for lkp "Milano" and for lkp2 "Berlin", this for both kinds of lookup (standard, devexpress)
                                    - now click on or tab into the standard-lkp2: you continue to see the text in standard-lkp ("Milano") but not in devexpress-lkp, because the lookup-datasource is filtered; infact, opening the lkp2 there is only "Berlin";

                                • Valdemar (DevExpress Support) 01.27.2011

                                  Hello Anton,
                                  I have tried to reproduce the problem you described, but failed. It looks like TcxDBLookupComboBox and TDBLookupComboBox controls demonstrate the same behavior.
                                  Could you please provide us with detailed step-by-step instructions on how to reproduce your problem.
                                  Also, please specify the version of our components you are using.
                                  Thanks,
                                  Valdemar

                                • ANTON SANTA 01.28.2011

                                  Hi Valdemar,
                                  the step showing the problem are:
                                  - in the grid above select the record with ID=2 and you will see for lkp "Milano" and for lkp2 "Berlin", this for both kinds of lookup (standard, devexpress)
                                  - now click on or tab into the standard-lkp2: you continue to see the text in standard-lkp ("Milano") but not in devexpress-lkp, because the lookup-datasource is filtered; infact, opening the lkp2 there is only "Berlin";
                                  So the devexpress-lookup should handle this behavior like the standard-lookup, not toggling the text when the datasource of the lookuplist is filtered.
                                  I hope you can reproduce the problem, now. I tried with Delphi 2007 and DelphiXE and the problem is always the same. DevExpress-components are updated to 1.54.
                                  best regards
                                  Tonni

                                1 Solution

                                Creation Date Importance Sort by

                                Hello Tonni,
                                Our developers have investigated your report. When you filter your tbLookup dataset, TcxDBLookupComboBox cannot more find a corresponding record for the selected DataSource record. So, it displays nothing. We believe that our TcxDBLookupComboBox has more correct behavior.
                                We have modified your sample to demonstrate this. You can see that the standard LookupComboBox does not display values at the application startup. You should change the focused row in the master Grid to force LookupComboBox to display a value. Then, please select the record with ID=2 and click the "set filter" button. The standard LookupComboBox will display "Milano". However, if you select the record with ID=2 and then move back to the first record, LookupComboBox will lose its text. It is incorrect behavior, because an editor should display the same value for the same conditions.
                                Thanks,
                                Valdemar

                                • ANTON SANTA 02.01.2011

                                  Hi Valdemar,
                                  I believe the behavior of the standard-lookups is more accurate. It's obvious the programmer has to set and toggle the filter only when the lookup is oben (dropped-down), so generally I set it in the dropdown-event and toggle it in the closeup-event. Doing this, the user cannot select an item form the list I don't want or he is not permitted to do (for example select an inactive customer. But obviously, for old records in the database the inactive customer should be shown, only for newly inserted orders he should not be selectable).
                                  Please, let me know if you plan to adapt the lookup-controls to have the same behavior of the standard-ones (also controls from Woll2Wool and TMS have the same). Thank you.
                                  Best regards
                                  Toni

                                • Valdemar (DevExpress Support) 02.02.2011

                                  Hello Anton,
                                  For now, we do not plan to change this behavior in the near future.
                                  We will inform you if we change this behavior.
                                  Thanks,
                                  Valdemar