I'm trying to open DBF file with complex index:
IF( LEN(ALLTRIM(HPHONE))=8, LEFT(ALLTRIM(HPHONE),3)+RIGHT(ALLTRIM(HPHONE),4),
LEFT(ALLTRIM(HPHONE),3)+SUBSTR(ALLTRIM(HPHONE),5,3))+RIGHT(ALLTRIM(HPHONE),4)))
and got following error:
ava.sql.SQLException: Can't parse index expression IF( LEN(ALLTRIM(HPHONE))=8, LEFT(ALLTRIM(HPHONE),3)+RIGHT(ALLTRIM(HPHONE),4),LEFT(ALLTRIM(HPHONE),3)+SUBSTR(ALLTRIM(HPHONE),5,3))+RIGHT(ALLTRIM(HPHONE),4)))
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.v.a(Unknown Source)
at com.hxtt.sql.dbf.l.char(Unknown Source)
at com.hxtt.sql.dbf.l.(Unknown Source)
at com.hxtt.sql.dbf.l.if(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.bl.if(Unknown Source)
at com.hxtt.sql.db.a(Unknown Source)
at com.hxtt.sql.db.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.dd.executeQuery(Unknown Source)
Is it possible to continue work with thsi DBF file, e.g. ignore this index?
Can you create some properties to turn on/off errors like this?
Thanks.
|
>SUBSTR(ALLTRIM(HPHONE),5,3))+RIGHT(ALLTRIM(HPHONE),4)))
Wrong () couple. It should be: SUBSTR(ALLTRIM(HPHONE),5,3)+RIGHT(ALLTRIM(HPHONE),4))
loadIndices: Indicates whether load automatically and update index files. Default value: true
You can use loadIndices=false.
|