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.