Create statement not executed

MobileBen · by **MobileBen** » Thu Mar 20, 2008 6:56 pm

Hello,

I tried the code example from this post.

http://www.anddev.org/working_with_the_ ... -t319.html

The database will be created perfectly but the Table isn't. It seems to me that the cde will not be executed but I don't know why. When I try this Create statement in the sqlite3 console it works.

Can anybody help me

This is the code:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

SQLiteDatabase myDB = null;
 
 try {
 
              /* Create the Database (no Errors if it already exists) */
 
              this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);
 
              /* Open the DB and remember it */
 
              myDB = this.openDatabase(MY_DATABASE_NAME, null);
 
              /* Create a Table in the Database. */
 
              myDB.execSQL("CREATE TABLE IF NOT EXISTS "
 
                                  + MY_DATABASE_TABLE
 
                                  + " (Name VARCHAR, bTime INT(2));");
 
              ....
Parsed in 0.031 seconds,  using GeSHi 1.0.8.4

Thx

Create statement not executed

Create statement not executed

Who is online