D'oh! Wow, can't believe I missed that... my first time using SQLite here, in case that wasn't already obvious. :p
The database gets created now. Thank you very much! A few follow-up questions: - Where do these error logs you speak of live? What exactly are adb logcat and DDMS? - How does a DATE datatype get converted from MySql into SQLite? Text? Blob? - sqlite.org is down at the moment, so I'll search around for other examples, but what are the main differences between MySQL and SQLite regarding INSERT statements? You're awesome - thanks again! On May 8, 7:23 am, Mark Murphy <[email protected]> wrote: > AJ wrote: > > Here's the full onCreate() function. Seems like standard SQL syntax > > to me? > > What was the error you got? You can get the error log from adb logcat or > DDMS. It should tell you what SQLite or Android did not like. > > > public void onCreate(SQLiteDatabase db) { > > db.execSQL("CREATE TABLE IF NOT EXISTS " > > + DATABASE_TABLE_USER > > + " (userID INT PRIMARY KEY, name > > VARCHAR(40)," > > There is no VARCHAR in SQLite. > > http://www.sqlite.org/datatype3.html > > > + " birthdate DATETIME," > > There is no DATETIME in SQLite. > > > + " weight INT(3), heightInches INT, " > > + " smoking BOOLEAN DEFAULT 'FALSE'," > > + " school BOOLEAN DEFAULT 'FALSE', " > > + " reading BOOLEAN DEFAULT 'FALSE'," > > + " religion BOOLEAN DEFAULT 'FALSE'," > > + " dating BOOLEAN DEFAULT 'FALSE');"); > > There is no BOOLEAN in SQLite. > > > db.execSQL("CREATE TABLE IF NOT EXISTS " > > + DATABASE_TABLE_ACH > > + " (achID INT PRIMARY KEY > > AUTO-INCREMENT, " > > AUTOINCREMENT has no hyphen in SQLite. > > http://www.sqlite.org/lang_createtable.html > > -- > Mark Murphy (a Commons > Guy)http://commonsware.com|http://twitter.com/commonsguy > > Android App Developer Training:http://commonsware.com/training.html --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
