cyntacks wrote: > GOT IT!!! This was driving me nuts for HOURS!!!! > > Long story short, SQLite does not validate fields, that is, you can > stick an INTEGER into a VARCHAR. My code was inserting an INTEGER into > a VARCHAR "assuming" it would be cast into a VARCHAR but in actuality > no conversion takes place, it was just being treated as an INTEGER, > thus my join failed becuase SQLite was seeing the entry as in INTEGER!
That's a SQLite-ism. Types expressed in table schemas are hints more so than mandates. -- Mark Murphy (a Commons Guy) http://commonsware.com Android Training on the Ranch! -- Mar 16-20, 2009 http://www.bignerdranch.com/schedule.shtml --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
