Hi,
I executed a select on one of my Clipper DBF file and i got the following error:
java.sql.SQLException: Can't parse index expression subs(opcnh_nf1,1,6)
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.v.a(Unknown Source)
at com.hxtt.sql.dbf.k.char(Unknown Source)
at com.hxtt.sql.dbf.k.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.(Unknown Source)
at com.hxtt.sql.dbf.DBFIndex.a(Unknown Source)
at com.hxtt.sql.dbf.i.a(Unknown Source)
at com.hxtt.sql.dbf.d.a(Unknown Source)
at com.hxtt.sql.dbf.d.(Unknown Source)
at com.hxtt.sql.dbf.u.a(Unknown Source)
at com.hxtt.sql.bm.if(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.de.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.bm.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dg.executeQuery(Unknown Source)
Are these kind of index expressions not supported by your engine?
Thanks in advance,
Marcelo
|
>subs(opcnh_nf1,1,6)
SUBS is an unknown function. Try SUBSTR. Or complement Extend SQL functions.
|
Main
webmaster@hxtt.com