Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DatabaseHelper mDbHelper = new DatabaseHelper(mCtx);
- SQLiteDatabase mDb = mDbHelper.getWritableDatabase();
- SQLiteDatabase mDc = mDbHelper.getReadableDatabase();
- //////
- Cursor mCursorZ = mDc.query(SQLITE_TABLE, new String[] { KEY_ROWID,
- PRODUCT_NAME, categoryName, price, categoryNum, qty }, null,
- null, null, null, null);
- Cursor mCursor = mDb.rawQuery("SELECT * FROM " + SQLITE_TABLE
- + " WHERE " + recordName + " ='" + ValueCheck + "'", null);
- if (mCursor != null && mCursor.moveToFirst()) {
- Toast.makeText(mCtx, "Available", 3000).show();
- String addQuery = "UPDATE " + SQLITE_TABLE +
- " SET "+ qty+"="+ qty +" + " + changedQTY +" ," +
- price + " = " + "(" + qty + " + " +changedQTY +")" +" *" +regPrice +
- " WHERE " +PRODUCT_NAME + "='" + changedPNAme + "';";
- mDb.execSQL(addQuery);
- mCursorZ.requery();
- } else {
- Toast.makeText(mCtx, "Not Available", 3000).show();
- createCountry(changedPNAme, theCategory, changedPrice, theCatN, changedQTY);
- mCursorZ.requery();
- /* record not exist */
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement