Devart Forums

Posted: **Sun 20 Dec 2015 16:10**

Hi people,

When i try to filter a IEntityEnumerable.where(statement) list a exception is throwed.(TSqlExpressionCalculator): Invalid node type { 46 }

Code: Select all

 var
    LCList: IEntityEnumerable<TContainer>;
    LCListFiltered: IObjectEnumerable<TContainer>;
    LWhere: string;
    LContainer: TContainer;
Begin
    LCList  := GetEntities;
    LWhere := '(Container.Aanduiding.Contains(''%' + edtContainerAanduiding.text + '%''))' +
            ' and (Container.ContainerNummer.Contains(''%' + edtContainerNummer.text + '%''))';   
   
    LCListFiltered := FCList.Where(LWhere);

    for LContainer in LCListFiltered do // Exception here...
    begin
        ....
    end;
End;

How to filter a list correctly?

Thanks for help.

Posted: **Tue 22 Dec 2015 10:42**

Hello,

We can't reproduce the issue on the latest EntityDAC version 1.4.7. Try to reproduce the issue on this version. If the issue repeats, please send us the model files (to support*devart*com), and specify the provider and the IDE version.

Posted: **Tue 22 Dec 2015 14:10**

Alex,

Thanks for response.
We try to reproduce the issue in 1.4.7, but the exception is throwed.
We will send the model to the support e-mail.

* Maybe a another bug:
TEntityContext: When change the property cache.enabled to false(design time), a acces validation is triggerd in 'EntityDac210.bpl' in Cache.TCacheManager.Clear.

Tech info:
Delphi XE7
Windows 10 64bit
SQL Server 2014.

Posted: **Wed 23 Dec 2015 08:04**

Thank you for the sample, we have reproduced the described problem and will investigate the reason for such behavior.

Devart Forums

Invalid node type exception

Invalid node type exception

Re: Invalid node type exception

Re: Invalid node type exception

Re: Invalid node type exception