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);
|
Hi
This seems to happen when an auto increment field is indexed.
|
|
Failed to recur your issue. Please send us your dbf sample with that index.
|
HI
I have send the files.
|
Main
webmaster@hxtt.com