To delete all rows of the table
db.delete("DATABASE_TABLE", null,null);
or you can drop the table ( which removes the table from db )
db.execSQL("DROP TABLE IF EXISTS DATABASE_TABLE");
On Sep 2, 12:25 pm, "Bharath B.G." <[email protected]> wrote:
> yup, its working, thank u thank u powerbyte
>
> hey also tell me how to wipe out the data, i mean to clear the tables etc
> tell mw where exactly the database files gonna store
>
> Regards,
> Bharath BG
>
>
>
>
>
> On Wed, Sep 2, 2009 at 10:24 AM, powerbyte <[email protected]> wrote:
>
> > add moveToFirst() after
> > Cursor c=db.query(DATABASE_TABLE, new String[] { COL_ID,COL_NAME},
> > null,
> > null, null, null, null);
>
> > c.moveToFirst();
>
> > and before closing db.close()
> > also close Cursor c.close();
>
> > On Sep 2, 9:17 am, "Bharath B.G." <[email protected]> wrote:
> > > *Here is the logcat, i got this when i changed the table name n hence
> > > created a new table
> > > also tell me how to wipe out the data from the database so that i can
> > clear
> > > all the tables*
>
> > > 09-02 09:41:51.778: ERROR/Database(710): Leak found
> > > 09-02 09:41:51.778: ERROR/Database(710): java.lang.IllegalStateException:
> > > /data/data/com.android/databases/myDatabse.db SQLiteDatabase created and
> > > never closed
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1580)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:638)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:659)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:652)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java:463)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:181)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > com.android.DatabaseWork.tryThis(DatabaseWork.java:35)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > com.android.DatabaseWork.onCreate(DatabaseWork.java:21)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1123)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2231)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2284)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.app.ActivityThread.access$1800(ActivityThread.java:112)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.os.Handler.dispatchMessage(Handler.java:99)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.os.Looper.loop(Looper.java:123)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > android.app.ActivityThread.main(ActivityThread.java:3948)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > java.lang.reflect.Method.invokeNative(Native Method)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > java.lang.reflect.Method.invoke(Method.java:521)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
>
> > com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:782)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540)
> > > 09-02 09:41:51.778: ERROR/Database(710): at
> > > dalvik.system.NativeStart.main(Native Method)
> > > 09-02 09:41:51.878: ERROR/Database(710): Leak found
> > > 09-02 09:41:51.878: ERROR/Database(710): java.lang.IllegalStateException:
> > > /data/data/com.android/databases/myDatabse.db SQLiteDatabase created and
> > > never closed
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1580)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:638)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:659)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:652)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java:463)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:181)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > com.android.DatabaseWork.tryThis(DatabaseWork.java:35)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > com.android.DatabaseWork.onCreate(DatabaseWork.java:21)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1123)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2231)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2284)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.app.ActivityThread.access$1800(ActivityThread.java:112)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.os.Handler.dispatchMessage(Handler.java:99)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.os.Looper.loop(Looper.java:123)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > android.app.ActivityThread.main(ActivityThread.java:3948)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > java.lang.reflect.Method.invokeNative(Native Method)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > java.lang.reflect.Method.invoke(Method.java:521)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
>
> > com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:782)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540)
> > > 09-02 09:41:51.878: ERROR/Database(710): at
> > > dalvik.system.NativeStart.main(Native Method)
>
> > > On Wed, Sep 2, 2009 at 9:41 AM, Bharath B.G. <[email protected]
> > >wrote:
>
> > > > Hi,
>
> > > > i put the code inside the try catch block and the error is bcoz of
> > > > tables(there may be other errors too but first i hav to remove this
> > error)
> > > > now my question is where exactly is the database files, where they get
> > > > stored...? in workspace or system32 folder or where...? bcoz i couldnt
> > find
> > > > the files anywhere, and how can i completely delete all the tables, so
> > that
> > > > i can create the database from the start
>
> > > > regards
> > > > Bharath BG
>
> > > > On Tue, Sep 1, 2009 at 6:01 PM, leonardo. <[email protected]
> > >wrote:
>
> > > >> You can put a
> > > >> try {
> > > >> db.execSQL("create table myTable (id integer primary key, name text
> > not
> > > >> null);");
> > > >> } catch(Exception e) {}
>
> > > >> to try to see the error??
>
> > > >> 2009/9/1 Bharath B.G. <[email protected]>
>
> > > >> Hi, I am very new to SQLite, i referred some books regarding coding in
> > > >>> SQLite n went straight for coding
>
> > > >>> But while i run my simple code i am getting error "the application
> > has
> > > >>> stopped unexpectadly" (particularly in the line create table)
>
> > > >>> please tell me where exactly is the error n where i hav to modify the
> > > >>> code
>
> > > >>> package com.android;
>
> > > >>> import android.app.Activity;
> > > >>> import android.content.Context;
> > > >>> import android.database.Cursor;
> > > >>> import android.database.sqlite.SQLiteDatabase;
> > > >>> import android.os.Bundle;
> > > >>> import android.widget.EditText;
>
> > > >>> public class DatabaseWork extends Activity {
>
> > > >>> private EditText et;
>
> > > >>> public void onCreate(Bundle icicle) {
> > > >>> super.onCreate(icicle);
>
> > > >>> setContentView(R.layout.main);
> > > >>> et=(EditText)findViewById(R.id.EditText01);
>
> > > >>> tryThis();
> > > >>> }
>
> > > >>> public void tryThis()
> > > >>> {
> > > >>> final String DATABASE_NAME="myDatabse.db";
> > > >>> final String DATABASE_TABLE="myTable";
> > > >>> final int DATABASE_VERSION=1;
>
> > > >>> final String COL_NAME="name";
> > > >>> final String COL_ID="id";
>
> > > >>> SQLiteDatabase db;
>
> > > >>> db=openOrCreateDatabase(DATABASE_NAME, 0, null);
> > > >>> db.execSQL("create table myTable (id integer primary key, name text
> > not
> > > >>> null);");
>
> > > >>> db.execSQL("insert into myTable values (1, \"Bharath\");");
> > > >>> db.execSQL("insert into myTable values (2, \"Abhijith\");");
>
> > > >>> Cursor c=db.query(DATABASE_TABLE, new String[] { COL_ID,COL_NAME},
> > null,
> > > >>> null, null, null, null);
>
> > > >>> int idCol=c.getColumnIndex(COL_ID);
> > > >>> int nameCol=c.getColumnIndex(COL_NAME);
>
> > > >>> String s=null;
>
> > > >>> while(true)
> > > >>> {
> > > >>> String name=c.getString(nameCol);
> > > >>> s=s+" "+name;
> > > >>> if(c.isLast())
> > > >>> {
> > > >>> break;
> > > >>> }
> > > >>> c.moveToNext();
> > > >>> }
>
> > > >>> et.setText(s);
>
> > > >>> db.close();
> > > >>> }
> > > >>> }
>
> > > >>> --
> > > >>> Bharath B.G.
>
> > > >> --
> > > >> Leonardo Ribeiro
> > > >> Desenvolvedor Java - iFactory Solutions
> > > >> SCJP 1.5
>
> > > > --
> > > > Bharath B.G.
>
> > > --
> > > Bharath B.G.- Hide quoted text -
>
> > > - Show quoted text -
>
> --
> Bharath B.G.- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
