>WHERE UPPER(P_NAME) LIKE UPPER('DEMELLO%')
You can use p_name ilike 'DEMELLO%'.
>WHERE P_NAME LIKE 'DEMELLO%'
>01/11 11:27:33.96 Error running GetResponse in >leindata_ddp:java.lang.NoSuchMethodError session:1
>java.lang.NoSuchMethodError
>at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
It means HXTT DBF is using your index file to quicken query, but can't call a compiled method. What's your JDK version?
|