Gary Lynch | 2016-08-31 02:59:48.0 | |
I use the PACK DATABASE command to encrypt the Access database and am noticing that some queries are returning a ResultSet ordered incorrectly. This appears to have been happening since I updated to a newer release some time ago.
For example: SELECT columnName FROM tableName WHERE floatValue>5 ORDER BY floatValue Will always return the rows ordered descending, even if I append ASC to the end. If I do: SELECT columnName FROM ( SELECT columnName FROM tableName WHERE floatValue>5 ) ORDER BY floatValue then the ResultSet is ordered correctly. | ||
HXTT Support | 2016-08-31 04:18:54.0 | |
Please check whether your tableName has a descending index on floatValue. | ||
Gary Lynch | 2016-08-31 07:57:17.0 | |
There was an index on the table but I removed it and it was still a problem.
I think I have fixed it now. The encrypted database was created using a slightly different version of the .jar to the one that was used in my application. Changing the application to use the same .jar file solves the problem. |