When ICS was released my app Wish l!st gained some weird crashes. After long debugging I found out that the reason for these crashes were the usage of the managedQuery() function to open cursors. When I went on debugging I … Continue reading
In one of my previous post I explained how to join two tables with SQLlite using a provider. Android Using joins with a provider (SQLite) That post may be a bit hard to understand if you do not have a … Continue reading
Last time I posted an article on how to fill a table with the help of a string array in a resource file: Android Filling a table from resource file using string array (SQLite) The drawback of that technique was … Continue reading
In this post we will be filling a table in our database with values from a resource xml file. You can use this technique to create default rows in your table on creation/updating of the database. Our resource file: res/values/mytable.xml … Continue reading
In this post I will show how to use a left outer join in your provider. Now note that you can also create a view in your database and query on the view. I might do a post on that … Continue reading