TCriteria and testing for ''

BIZ TMS Aurelius
1
I can?t get this to work:

This works ok:
Criteria.Add(Linq.IsNotNull('LebensmittelCD'));

I want to test for empty strings additionally:
This
Criteria.Add(Linq.IsNotNull('LebensmittelCD') and (Linq['LebensmittelCD'] <> ''));
as well as this
Criteria.Add(Linq.IsNotNull('LebensmittelCD'));
Criteria.Add(not Linq.Eq('LebensmittelCD',''));

does not return any rows - but should return 5.


The trace Shows (have alook at the missing Operator!!):
Debug-Ausgabe:
[23.10.2019 15:46:00][Trace][Value: SELECT A.ID AS A_ID, A.IDExtern AS A_IDExtern, A.BezeichnungExtern AS A_BezeichnungExtern, A.HerkunftCD AS A_HerkunftCD, A.LebensmittelCD AS A_LebensmittelCD, A.Bezeichnung AS A_Bezeichnung
FROM TBLXLSImport A
WHERE  A.BezeichnungExtern LIKE :p_0 AND
(A.LebensmittelCD Is Not Null And A.LebensmittelCD  :p_1)][Type: string]
Prozess RezeptSchnittstelle.exe (6424)
Debug-Ausgabe: [23.10.2019 15:46:00][Trace][Value: p_0 = "%%" (ftString)][Type: string] Prozess RezeptSchnittstelle.exe (6424)
Debug-Ausgabe: [23.10.2019 15:46:00][Trace][Value: p_1 = "" (ftString)][Type: string] Prozess RezeptSchnittstelle.exe (6424)
2
The missing operator is a quirk in the logger, so that is not the problem.
If I compare against a blank instead of an empty string, the result is ok.
If I execute the query in Management Studio (even with Parameters) the result is ok.

3

What does this mean?
4
Instead of
Criteria.Add(Linq.IsNotNull('LebensmittelCD') and (Linq['LebensmittelCD'] <> ''));
this one
Criteria.Add(Linq.IsNotNull('LebensmittelCD') and (Linq['LebensmittelCD'] <> ' '));

BTW: Criteria.Add(Linq.IsNotNull('LebensmittelCD') and (Linq['LebensmittelCD'].Len > 0 ));
works too.
5

I cannot reproduce the problem, can you please provide more details? 

Maybe a sample project that reproduces the issue? 
What database are you using? Which version?
What component are you using to connect to the database?
6

Isn't this the same problem with old SQL Server driver?

7

No, this is the new driver.

8

Can you please provide a project via e-mail that reproduces the problem? It depends on data in the database as well.