Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
Can't parse index expression
Bart Pollet
2007-02-01 00:46:25.0
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.
Re:Can't parse index expression
HXTT Support
2007-02-01 03:11:31.0
>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.
Re:Re:Can't parse index expression
Bart Pollet
2007-02-01 06:26:01.0
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.
Re:Re:Re:Can't parse index expression
HXTT Support
2007-02-01 06:33:59.0
Are you using IDX suffix index file, not NTX suffix?
Re:Re:Re:Re:Can't parse index expression
HXTT Support
2007-02-01 07:02:15.0
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.
Re:Re:Re:Re:Re:Can't parse index expression
Bart Pollet
2007-02-01 07:50:21.0
The expressions are all in CDX index files.
How unfortunate ! Can it be done in the future ?

Bart Pollet
Re:Re:Re:Re:Re:Re:Can't parse index expression
HXTT Support
2007-02-01 16:55:06.0
Supported now:)
Re:Re:Re:Re:Re:Re:Re:Can't parse index expression
Bart Pollet
2007-02-02 02:23:59.0
Seems to work fine now.
Good job !
Thanks for the very fast reaction.

Bart.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap