Willie | 2008-01-12 12:48:46.0 | |
| Hi
I am getting the following error when I try to connect to a dBase level 7 file with an index. The Query has no problem without the index. Exception in thread "main" java.sql.SQLException: Failed to calculate index value for index expression ID at com.hxtt.global.SQLState.SQLException(Unknown Source) at com.hxtt.sql.dbf.v.a(Unknown Source) The code is as follows; Class.forName("com.hxtt.sql.dbf.DBFDriver").newInstance(); String jdbcConnection = "jdbc:dbf:///D:/dms"; String sql = "select * from HXTT WHERE ID > 0"; Connection con = DriverManager.getConnection(jdbcConnection, "", ""); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql); | ||
Willie | 2008-01-15 01:35:14.0 | |
| Hi
This seems to happen when an auto increment field is indexed. | ||
HXTT Support | 2008-01-16 05:32:37.0 | |
| Failed to recur your issue. Please send us your dbf sample with that index. | ||
Willie | 2008-01-23 23:52:51.0 | |
| HI
I have send the files. | ||