private String getBlockLongText(String blockName) { SQLiteDatabase db = textData.getReadableDatabase(); Cursor cursor = db.query(TextSQLHelper.TABLE, null, "block= '" + blockName + "'", null, null, null, null); startManagingCursor(cursor); if (cursor.moveToFirst() == true) { return cursor.getString(2); } else return ""; }
private void setBlockLongText(String blockName, String blockLongText) { SQLiteDatabase db = textData.getWritableDatabase(); ContentValues args = new ContentValues(); args.put(TextSQLHelper.DATA, blockLongText); String strFilter = " block='" + blockName + "'"; int retval = db.update(TextSQLHelper.TABLE, args, strFilter, null); if (retval == 0) { args.put(TextSQLHelper.BLOCK, blockName); long retret = db.insert(TextSQLHelper.TABLE, null, args); } }