mardi 23 février 2016

Inner join not working with SqlliteCipher and activeAndroid

I am working on SqliteCipher along with using the active android library.

When I am trying to use the Inner Join with active android it is working fine and giving me the proper result of data. Below is the my Db Query.

SELECT * 
FROM   mydata 
       INNER JOIN folder_mydata_rel 
               ON mydata.reference_id = folder_mydata_rel.record_id 
                  AND folder_mydata_rel.folder_id = ? 
ORDER  BY folder_mydata_rel.created_at DESC; 

List<MyDataBo> records = SQLiteUtils.rawQuery(MyDataBo.class, "Above query", new String[]{folderId+""});

It gives me the list of MyDataBo with all values in like int , long, strings , dates etc.

But When I implemented the SqliteCipher to encrypt my database With ActiveAndroid and trying to use the same query, it is not given me the same result.

Means it still gives the list but all int, long values are 0. Which are actually not zeros.

Can someone help?

Aucun commentaire:

Enregistrer un commentaire