AJ wrote: > D'oh! Wow, can't believe I missed that... my first time using SQLite > here, in case that wasn't already obvious. :p
It's close enough to the SQL used in other places that you sometimes forget the idiosyncrasies. > - Where do these error logs you speak of live? What exactly are adb > logcat and DDMS? http://developer.android.com/guide/developing/tools/ddms.html http://developer.android.com/guide/developing/tools/adb.html > - How does a DATE datatype get converted from MySql into SQLite? > Text? Blob? I can't speak for MySQL. With respect to SQLite, I've seen both string representations (e.g., ISO 8601) and integer representations (Unix epoch/seconds-since-1970). > - sqlite.org is down at the moment It's working for me here. > so I'll search around for other > examples, but what are the main differences between MySQL and SQLite > regarding INSERT statements? I haven't played much with MySQL in ages. INSERT is pretty close to ANSI SQL, though, IIRC. -- Mark Murphy (a Commons Guy) http://commonsware.com | http://twitter.com/commonsguy Android Development Wiki: http://wiki.andmob.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" 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-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
