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
Error in index
Remco Schoen
2009-06-19 07:35:03.0
We are currently looking into the DBF driver to get information from our Visual FoxPro 9 database. We are using a database container and we are using long column names.

We have a file structure like this, with the tables in a sub-directory "data" next to the database container:
dbs.DBC
data/test.DBF

In the table test we have a column "gebruikerid" with an index.

If we execute the statement "select gebruikerid from data.test" we get the following error:

Index /Users/remco/dev/import/test_jdbc/testdb/data/test.CDX should have an invalid index expression gebruikerid, since failed to find column gebruikerid !

It seems there is problem resolving the long column name used in the index. It looks like it isn't using the database container to resolve the column name.

Can this be solved?

With kind regards,

Remco Schoen
Re:Error in index
HXTT Support
2009-06-20 03:33:42.0
v4.2.066 can retrieve long column name information from database container at parent directory. It'll be release in about 8 hours.
Re:Error in index
Remco Schoen
2009-06-23 01:05:04.0
I downloaded and tried the new version, but I'm still getting the same error:
Index /Users/remco/dev/import/test_jdbc/testdb/data/test.CDX should have an invalid index expression gebruikerid, since failed to find column gebruikerid !

Looking at this error-message, it looks like something is checking the index, but fails to find the long column name and then thinks the index should be invalid.

I see I made an error in my mailaddress, I have now used the correct one.

Kind regards,

Remco
Re:Re:Re:Error in index
HXTT Support
2009-06-23 03:17:34.0
>/Users/remco/dev/import/test_jdbc/testdb/data/test.CDX
Are you using Linux. Maybe it's a case sensitive issue. Please send us your test sample database since we failed to recur your issue with the latest version.
Re:Re:Re:Re:Error in index
Remco Schoen
2009-06-23 03:38:09.0
I'm using and testing it on OS X 10.5.7, which is Linux-based.

I've send the test-database to your support address.
Re:Re:Re:Re:Re:Error in index
Remco Schoen
2009-06-23 04:41:36.0
I gave the new version a try on a Windows-machine and there it worked ok. So it seems to be a case-sensitivity issue.
Re:Re:Re:Re:Re:Re:Error in index
HXTT Support
2009-06-23 20:00:29.0
It's a case-sensitive issue. On Linux, it failed to find dbs.dbc according to the stored path information in dbf file on Windows. Supported. The latest package will be released in 8 hours.
Re:Re:Re:Re:Re:Re:Re:Error in index
Remco Schoen
2009-06-25 01:01:00.0
I tried version 4.2.068 on June 24, 2009, but I'm still getting the same error.
Re:Re:Re:Re:Re:Re:Re:Re:Error in index
HXTT Support
2009-06-25 09:24:47.0
Please download the latest v4.2.069, which will check and convert the relative Windows path to Linux path.
Re:Re:Re:Re:Re:Re:Re:Re:Error in index
Remco Schoen
2009-06-26 02:10:59.0
Tried it with the 4.2.069, but still the same error-message.

Which path did you convert? The one in the table or the one in the database container?

If I change the path with a text-editor in the file dbs.DCT, it works. So it looks like the path in the database container isn't converted.
Re:Re:Re:Re:Re:Re:Re:Re:Error in index
HXTT Support
2009-07-01 23:25:37.0
The latest package passed test on MAC OS X. Please download it.
Re:Re:Re:Re:Re:Re:Re:Re:Error in index
Remco Schoen
2009-07-03 01:52:46.0
Cool, I gave it a try and it works. Great job!

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