Finally, we have a functional build of BM out on the App Store. I have no earthly clue why Drew and I never ran into the odd primary key bug prior to the release of 1.0. Bleh. Download the update and revise your review, por favor.
Tag Archive for 'billminder'
I was showing BillMinder to some folks the other day using the iPhone simulator. It turns out that calling trim on a NSString with a tab at the end causes the string to be duplicated. This isn’t much of an issue on the phone itself since there isn’t a tab key. I thought it was a BillMinder bug but in reality, not so much. Go band.
We pushed BillMinder 1.0 to Apple a few days back, while it was in review, firmware 2.1 hit. We were using it on our phones but already had our bills setup so it seemed to work well. In reality, adding new bills (well, adding new anything that resulted in a database row being created failed). It ends up that the function sqlite3_last_insert_rowid returned zero instead of the pk for the last inserted row after the first call — bad times. This meant strange things happened (like bills being duplicated or disappearing, etc.).
Our “fix” was simply to select pk from table order by pk desc and use that value. It seems to work well — we put in the change, fixed some other minor usability issues and BillMinder 1.01 is on its way to users. Talk about a headache. The moral of this story is test your software from a clean DB after a new firmware hits.
Update: This does not seem to be an issue w/ iPhone 2.1 but rather an issue that occurs after inserting 3 rows and calling sqlite3_last_insert_rowid 3 times, as far as I can tell
BillMinder and CastCatcher have been sent to Apple and are pending approval. Look for them in about a week, if all goes well.
Recent Comments