Slow progress and fighting with sqlite
Second day at the (home) office was harder than the first. Fiddling with queries on sqlite took up a lot of the day. I have been doing sql for years, but I think I will just have to test the stuff out more thoroughly before I put it into an android program. The cycle between develop, deploy and test is too long and fiddly to be working out why your where clause is eliminating all of your rows. Outer join - I added an outer join to my code today. Not exactly rocket science, but very handy all the same. The app I am developing allows people pick 30 day challenges. They enter their progress against these items as they go along. It is supposed to be a way to get into new, productive habits. I got the idea here: http://www.youtube.com/watch?v=JnfBXjWm7hc Its early days yet, but I like these kind of apps, so it seemed like as good a place as any to start. The outer join is useful for pulling back the tasks that the user has in their list. It is outer as I want to show them the ones th...