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." wrote:
> yup, its working, thank u thank u powerbyte
>
> hey also t
go to File explorer
there
data \data \package name
here Databases folder
in this folder databases we can see
On Wed, Sep 2, 2009 at 12:55 PM, Bharath B.G. 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
>
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 wrote:
>
> add moveToFirst() after
> Cursor c=db.query(DATAB
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." wrote:
> *Here is the logcat, i got this when i changed the
*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.IllegalStateE
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 f
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.
> Hi, I am very new to SQLite, i referred some books regarding coding in
> SQLite n went straight for coding
>
> But whil
Look at the system log ('adb logcat' , or the logcat tab in the DDMS
perspective in Eclipse), and it will tell you exactly where and why
your app crashed.
On Mon, Aug 31, 2009 at 11:56 PM, Bharath B.G. wrote:
> Hi, I am very new to SQLite, i referred some books regarding coding in
> SQLite n wen
Have you checked the value of db before the call to
openOrCreateDatabase ?
On Sep 1, 12:56 am, "Bharath B.G." wrote:
> 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
9 matches
Mail list logo
