Edit application database

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

Edit application database

Postby abdo19 » Fri Feb 05, 2010 7:51 am

Hi all,

How can I edit an SQLite database after it has been created and stored on my phone together with the corresponding app?

I want to add a new column to the database but I can't figure out how.
Is it possible to do this in code?

I tried to just update it by adding the column, but then the app fails at compile time with the following Exception:

android.database.sqlite.SQLiteException: There is no column named type in the table Locations

(type is the name of the column )

is there any solution?

Thanks in advance
Posts: 7
Joined: Sun Oct 25, 2009 6:14 pm



Postby androidbase » Fri Feb 05, 2010 3:32 pm

use this mehtod managedquery with corresponing args

http://developer.android.com/reference/ ... ang.String[],%20java.lang.String,%20java.lang.String[],%20java.lang.String%29

store it in a cursor and u can do what u want...... :D :D :D
Experienced Developer
Experienced Developer
Posts: 50
Joined: Sat Jan 16, 2010 1:41 pm


Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 3 guests