DataBlock & Microsoft Access Like Query Error and Solution

[Mustafa OZCAN]

There no return result by using Like query in DataBlock.
I can inspect this. And find a solution.

You must change DataBlock Source Code :

In AccessQueryCriteriaGenerator.cs

this line

case CriteriaOperator.Like:
field.fieldValue = "*" +
conditions[i].Values[0].ToString() + "*";

change this

case CriteriaOperator.Like:
field.fieldValue = "%" +
conditions[i].Values[0].ToString() + "%";

and change "*" char to "%" in other like variation's.

finally rebuild DataBlock and use it perfectly...