#25 Hidden queries

[Serg]

Hello,

If an MS Access file has hidden queries (queries with the “hidden” attribute set) Jackcess writes the following warnings:
java.lang.IllegalStateException: unknown query object flag 8
at com.healthmarketscience.jackcess.query.Query.create(Query.java:427)
at com.healthmarketscience.jackcess.Database.getQueries(Database.java:1665)
java.lang.IllegalStateException: unknown query object flag 136
at com.healthmarketscience.jackcess.query.Query.create(Query.java:427)
at com.healthmarketscience.jackcess.Database.getQueries(Database.java:1665)

Also there are the following unknown object flags I encountered: 24 (0x18h), 40 (0x28h), 72 (0x48h).
It seems that all of the flag codes listed above have a common hex digit, 8. Probably 4th bit must be the flag for hidden.

Is it possible to support such queries? Test file is attached. Many thanks.

[James Ahlborn]

This will actually be handled in two separate releases. A basic fix will be released in 1.2.14.1 which will effectively remove the hidden flag so the types are interpreted correctly.

Jackcess is in the midst of a bit of a refactor for a 2.x release. in the 2.0.0 release, there will be a new isHidden() method on Query and the getObjectFlag() method will return all the original object flags (not just the type flag).