Re: [android-developers] Re: SQLite Transactions

Thanks Kostya, I did find this out too :) David Williams Check out our WebOS mobile phone app for the Palm Pre and Pixi: Golf Caddie | G

Re: [android-developers] Re: SQLite Transactions

Or, to use the pattern from documentation: db.beginTransaction(); try { db.execSQL(...); db.execSQL(...); db.setTransactionSuccessful(); } finally { db.endTransaction(); } The semantics are a little different, because beginTransaction() uses EXCLUSIVE transaction mode, while "BEGIN TRANSACTIO

Re: [android-developers] Re: SQLite Transactions

16.03.2011 4:46, David Williams ?: Ok, why isn't this working. Only the first CREATE TABLE command works, the rest don't :( This works fine when I copy and paste this command into an sqlite window and run it. http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.h

Re: [android-developers] Re: SQLite Transactions

Ok, why isn't this working. Only the first CREATE TABLE command works, the rest don't :( This works fine when I copy and paste this command into an sqlite window and run it. This is my DATABASE_CREATE string that I have set up: public final static String DATABASE_CREATE = "CREATE TABLE playe

Re: [android-developers] Re: SQLite Transactions

I'm not familiar with this, unless it is familar with begin / end in regular SQL. So, the overall statement would be something like this. BEGIN CREATE TABLE table1 (..); CREATE TABLE table2 (..); CREATE TABLE table3 (..); . . . CREATE TABLE tablex (..