The new driver does not query correctly when I use a Like statement. If I replace the Like with = the query returns a result egg.
String sql = "select * from punit where PUNIT LIKE 'Line01'";
Connection conn = DriverManager.getConnection("jdbc:dbf:/d:/dms2000/data/dms?lockType=DBASE4BDE");
>select * from punit where PUNIT LIKE 'Line01'
It will be converted inoto
select * from punit where PUNIT='Line01' by the HXTT DBF engine.
What's your want result? Maybe you need ILIKE?
select * from punit where PUNIT ILIKE 'Line01'