I think that this is a problem of the JDBC access driver. With the following query using HXTT driver, an empty result is returned:
SELECT KEY1 , KEY2 , KEY3 , VALUE FROM TESTDATA WHERE ((( KEY1 IN ( 3669,3670) ) )AND(( KEY2 IN ( 3669,3670) ) ))
However this is what i have in the db:
KEY1 KEY2 KEY3 VALUE
3669 3670 exec1 1.0
3670 3669 exec1 2.0
But it works with a selection that is a subset of the above:
SELECT KEY1 , KEY2 , KEY3 , VALUE FROM TESTDATA WHERE ((( KEY1 IN ( 3669,3670) ) )AND(( KEY2 IN ( 3670) ) ))
This problem goes in had with another one that is still unresolved:
The MDB file I am using is fine, I can use it normally with others drivers and get proper results.
Do you have estimates to fix these problems?
Sorry for missing the previous thread. v3.0.031 fixed a bug on utilizing part expression of component index to quicken IN query. It should be availabe after about 24 hours.