Error in index |
Remco Schoen |
2009-06-19 07:35:03 |
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 |
|
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 |
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 |
>/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 |
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 |
|
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 |
|
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 |
|
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 |
|
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 |
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 |
|
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 |
|
Cool, I gave it a try and it works. Great job!
|
Main
webmaster@hxtt.com