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 | ||
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. | ||
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 | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
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. | ||
HXTT Support | 2009-07-01 23:25:37.0 | |
| The latest package passed test on MAC OS X. Please download it. | ||
Remco Schoen | 2009-07-03 01:52:46.0 | |
| Cool, I gave it a try and it works. Great job! | ||