Databases
StackOverflow2013
Postsdbo
POsqlite update query error on android
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsqlite update query error on android
    primarykey
    data
    text
    <p>when i try to update my data on sqlite this error occur </p> <pre><code>07-04 07:20:52.289: E/AndroidRuntime(2633): android.database.sqlite.SQLiteException: no such column: nick (code 1): , while compiling: UPDATE Contacts SET phone=?,nick=?,_id=?,name=? WHERE _id=2 </code></pre> <p>i didnt understand why this error is occured. i think variables dont transfer to the update query</p> <p>here is my update query</p> <pre><code>public void update(int id, String name, String phone, String nick) throws SQLException{ ContentValues cvUpdate=new ContentValues(); cvUpdate.put(KEY_ID,id); cvUpdate.put(KEY_NAME,name); cvUpdate.put(KEY_PHONE,phone); cvUpdate.put(KEY_NICK,nick); ourDatabase.update(DATABASE_TABLE, cvUpdate, KEY_ID+"="+id, null); </code></pre> <p>and i get the values from edittext andi put these values into string and int variables in mainactivity then i write this code:</p> <pre><code> info.open(); info.update(intid, contactname, contactphone, contactnick); info.close(); </code></pre> <p>this is database cretaion public class contacts_nick {</p> <pre><code>//private static final String TAG = contacts_nick.class.getSimpleName(); public static final String KEY_ID="_id"; public static final String KEY_NAME="name"; public static final String KEY_PHONE="phone"; public static final String KEY_NICK="nick"; private static final String DATABASE_NAME="mydb"; private static final String DATABASE_TABLE="Contacts"; private static final int DATABASE_VERSION=1; private DbHelper ourHelper; private final Context ourContext; private SQLiteDatabase ourDatabase; private static class DbHelper extends SQLiteOpenHelper{ public DbHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); // TODO Auto-generated constructor stub } @Override //To create db public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " +DATABASE_TABLE+ " (" +KEY_ID+ " INTEGER PRIMARY KEY AUTOINCREMENT, "+KEY_NAME+" TEXT, "+KEY_PHONE+" TEXT);"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE); onCreate(db); } } public contacts_nick(Context c){ ourContext=c; } public contacts_nick open() throws SQLException{ ourHelper=new DbHelper(ourContext); ourDatabase=ourHelper.getWritableDatabase(); return this; } public contacts_nick open_read() throws SQLException{ ourHelper=new DbHelper(ourContext); ourDatabase=ourHelper.getReadableDatabase(); return this; } public void close(){ ourHelper.close(); } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USantoniom
    1. USFahri_D
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POsqlite update query error on android
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COare you sure you'r creation command for database is exact what you want ? I think there is a problem on creating you'r nik column .
      singulars
      1. POsqlite update query error on android
      1. USpooyan
    2. COif it's possible let me know your creation command for your DB .
      singulars
      1. POsqlite update query error on android
      1. USpooyan
    3. COyes my database do creation and insertion activity but not update i will send a db creation
      singulars
      1. POsqlite update query error on android
      1. USFahri_D
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload