dms2000 | 2009-11-15 00:00:58.0 | |
| Hi
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"); Please advise. | ||
HXTT Support | 2009-11-15 00:09:02.0 | |
| >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' | ||