Change your database version to recreate the table.
On Dec 29, 2011 1:14 PM, "Jeresam515" <[email protected]> wrote:
> Thanks, I fixed that still have the same error though, here's my new
> code.
> package com.drawing;
>
> import android.content.ContentValues;
> import android.content.Context;
> import android.database.Cursor;
> import android.database.SQLException;
> import android.database.sqlite.SQLiteDatabase;
> import android.database.sqlite.SQLiteOpenHelper;
> import android.util.Log;
>
> public class NotesDbAdapter {
>
> public static final String KEY_ROWID = "_id";
> public static final String KEY_X = "x";
> public static final String KEY_Y = "y";
> public static final String KEY_Size = "size";
> private static final String TAG = "NotesDbAdapter";
> private DatabaseHelper mDbHelper;
> private SQLiteDatabase mDb;
> private static final String DATABASE_NAME = "data";
> private static final String DATABASE_TABLE = "notes";
> private static final int DATABASE_VERSION = 2;
> private static final String DATABASE_CREATE =
> " create table " +DATABASE_TABLE+ " ("
> +KEY_ROWID+ " integer primary key autoincrement, "
> +KEY_X+ " integer, "
> +KEY_Y+ " integer, "
> +KEY_Size+ " integer);";
> private final Context mCtx;
>
> private static class DatabaseHelper extends SQLiteOpenHelper {
>
> DatabaseHelper(Context context) {
> super(context, DATABASE_NAME, null, DATABASE_VERSION);
> }
>
>
> @Override
> public void onCreate(SQLiteDatabase db) {
> try {
> db.execSQL(DATABASE_CREATE);
> } catch (Exception e) {
> Log.e("dbAdapter", e.getMessage().toString());
> }
> }
>
> @Override
> public void onUpgrade(SQLiteDatabase db, int oldVersion, int
> newVersion) {
> Log.w(TAG, "Upgrading database from version " + oldVersion
> + " to "
> + newVersion + ", which will destroy all old
> data");
> db.execSQL("DROP TABLE IF EXISTS notes");
> onCreate(db);
> }
>
> }
>
> public NotesDbAdapter(Context ctx) {
> this.mCtx = ctx;
> }
>
> public NotesDbAdapter open() throws SQLException {
> mDbHelper = new DatabaseHelper(mCtx);
> mDb = mDbHelper.getWritableDatabase();
> return this;
> }
>
> public void close() {
> mDbHelper.close();
> }
>
>
> public long createNote(float f, float g, int size) {
> ContentValues initialValues = new ContentValues();
> initialValues.put(KEY_X, f);
> initialValues.put(KEY_Y, g);
> initialValues.put(KEY_Size, size);
> return mDb.insert(DATABASE_TABLE, null, initialValues);
> }
>
> public boolean deleteNote(long rowId) {
>
> return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId,
> null) > 0;
> }
>
>
> public Cursor fetchAllNotes() {
>
> return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID,
> KEY_X,KEY_Y,KEY_Size}, null, null, null, null, null);
> }
>
> public Cursor fetchNote(long rowId) throws SQLException {
>
> Cursor mCursor =
>
> mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,
> KEY_X,KEY_Y,KEY_Size}, KEY_ROWID + "=" + rowId, null,
> null, null, null, null);
> if (mCursor != null) {
> mCursor.moveToFirst();
> }
> return mCursor;
>
> }
>
> public boolean updateNote(long rowId, int x, int y, int size) {
> ContentValues args = new ContentValues();
> args.put(KEY_X, x);
> args.put(KEY_Y, y);
> args.put(KEY_Size, size);
> return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" +
> rowId, null) > 0;
> }
> }
>
>
> On Dec 28, 2:57 pm, Kostya Vasilyev <[email protected]> wrote:
> > Are all these supposed to be mapped to the same column, "_id", or is
> this a
> > copy / paste artifact?
> >
> > public static final String KEY_ROWID = "_id";
> > public static final String KEY_X = "_id";
> > public static final String KEY_Y = "_id";
> > public static final String KEY_Size = "_id";
> >
> > 29 декабря 2011 г. 1:50 пользователь Jeresam515
> > <[email protected]>написал:
> >
> >
> >
> >
> >
> >
> >
> > > I did the notepad tutorials, and am using a modified version of that
> > > for my database. I don't understand why my program isn't correctly
> > > writing to it. Help would be greatly appreciated.
> >
> > > package com.drawing;
> >
> > > import android.content.ContentValues;
> > > import android.content.Context;
> > > import android.database.Cursor;
> > > import android.database.SQLException;
> > > import android.database.sqlite.SQLiteDatabase;
> > > import android.database.sqlite.SQLiteOpenHelper;
> > > import android.util.Log;
> >
> > > public class NotesDbAdapter {
> >
> > > public static final String KEY_ROWID = "_id";
> > > public static final String KEY_X = "_id";
> > > public static final String KEY_Y = "_id";
> > > public static final String KEY_Size = "_id";
> > > private static final String TAG = "NotesDbAdapter";
> > > private DatabaseHelper mDbHelper;
> > > private SQLiteDatabase mDb;
> > > private static final String DATABASE_CREATE =
> > > "create table notes (_id integer primary key autoincrement, "
> > > + "title text not null, body text not null);";
> >
> > > private static final String DATABASE_NAME = "data";
> > > private static final String DATABASE_TABLE = "notes";
> > > private static final int DATABASE_VERSION = 2;
> >
> > > private final Context mCtx;
> >
> > > private static class DatabaseHelper extends SQLiteOpenHelper {
> >
> > > DatabaseHelper(Context context) {
> > > super(context, DATABASE_NAME, null, DATABASE_VERSION);
> > > }
> >
> > > @Override
> > > public void onCreate(SQLiteDatabase db) {
> >
> > > db.execSQL(DATABASE_CREATE);
> > > }
> >
> > > @Override
> > > public void onUpgrade(SQLiteDatabase db, int oldVersion, int
> > > newVersion) {
> > > Log.w(TAG, "Upgrading database from version " + oldVersion
> > > + " to "
> > > + newVersion + ", which will destroy all old
> > > data");
> > > db.execSQL("DROP TABLE IF EXISTS notes");
> > > onCreate(db);
> > > }
> > > }
> >
> > > public NotesDbAdapter(Context ctx) {
> > > this.mCtx = ctx;
> > > }
> >
> > > public NotesDbAdapter open() throws SQLException {
> > > mDbHelper = new DatabaseHelper(mCtx);
> > > mDb = mDbHelper.getWritableDatabase();
> > > return this;
> > > }
> >
> > > public void close() {
> > > mDbHelper.close();
> > > }
> >
> > > public long createNote(float f, float g, int size) {
> > > ContentValues initialValues = new ContentValues();
> > > initialValues.put(KEY_X, f);
> > > initialValues.put(KEY_Y, g);
> > > initialValues.put(KEY_Size, size);
> > > return mDb.insert(DATABASE_TABLE, null, initialValues);
> > > }
> >
> > > public boolean deleteNote(long rowId) {
> >
> > > return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId,
> > > null) > 0;
> > > }
> >
> > > public Cursor fetchAllNotes() {
> >
> > > return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID,
> > > KEY_X,KEY_Y,KEY_Size}, null, null, null, null, null);
> > > }
> >
> > > public Cursor fetchNote(long rowId) throws SQLException {
> >
> > > Cursor mCursor =
> >
> > > mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,
> > > KEY_X,KEY_Y,KEY_Size}, KEY_ROWID + "=" + rowId, null,
> > > null, null, null, null);
> > > if (mCursor != null) {
> > > mCursor.moveToFirst();
> > > }
> > > return mCursor;
> >
> > > }
> >
> > > public boolean updateNote(long rowId, int x, int y, int size) {
> > > ContentValues args = new ContentValues();
> > > args.put(KEY_X, x);
> > > args.put(KEY_Y, y);
> > > args.put(KEY_Size, size);
> > > return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" +
> > > rowId, null) > 0;
> > > }
> > > }
> >
> > > --
> > > 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
>
> --
> 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
--
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
