Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan 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
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap