Hi,
While evaluating your DBF driver on a set of Clipper DBF files, I got following errors :
Error: java.sql.SQLException: Can't parse index expression UPPER(ARTIKEL->ARTCODE), SQL State: 42000, Error Code: 270336
or
Error: java.sql.SQLException: Can't parse index expression DTOS(ARTLEV->LDATUM)+ARTLEV->LUUR, SQL State: 42000, Error Code: 270336
Are these kind of index expressions not supported by your engine ?
I can eliminate the messages by not loading the indices :
jdbc:dbf:/?loadIndices=false
But, if I do so, I suppose I leave an inconsistent database if I update or add records. Right ?
Thanks in advance for your answer,
Bart Pollet.
|
>Can't parse index expression UPPER(ARTIKEL->ARTCODE)
Because it doesn't support tableName->columnName format. Please download the latest package, which should support your situation according to your request.
|
Now I got the error message :
"com.hxtt.sql.dbf.b cannot be cast to com.hxtt.sql.dbf.k"
if I don't append the "?loadIndices=false" clause to the url.
TNX,
Bart Pollet.
|
|
Are you using IDX suffix index file, not NTX suffix?
|
|
The latest package has fixed that new issue, but it won't support your IDX(CDX) index which has such an expression. If UPPER(ARTIKEL->ARTCODE) is in NTX file, it should support.
|
The expressions are all in CDX index files.
How unfortunate ! Can it be done in the future ?
Bart Pollet
|
Seems to work fine now.
Good job !
Thanks for the very fast reaction.
Bart.
|
Main
webmaster@hxtt.com