public static synchronized SQLiteDatabase getDatabase(DatabaseMode mode) {
checkState();
+ SQLiteDatabase db;
+
if (mode == READ) {
if (helperForReading == null) helperForReading = new MobileLedgerDatabase(context);
- return helperForReading.getReadableDatabase();
+ db = helperForReading.getReadableDatabase();
}
else {
if (helperForWriting == null) helperForWriting = new MobileLedgerDatabase(context);
- return helperForWriting.getWritableDatabase();
+ db = helperForWriting.getWritableDatabase();
}
+
+ db.execSQL("pragma case_sensitive_like=ON;");
+ return db;
}
public static SQLiteDatabase getReadableDatabase() {
return getDatabase(READ);
public static void hookAutocompletionAdapter(final Context context,
final AutoCompleteTextView view,
final String table, final String field,
- final boolean profileSpecific,
- final View nextView,
+ final boolean profileSpecific, final View nextView,
final DescriptionSelectedCallback callback) {
String[] from = {field};
int[] to = {android.R.id.text1};
class MobileLedgerDatabase extends SQLiteOpenHelper implements AutoCloseable {
public static final String DB_NAME = "MoLe.db";
- public static final int LATEST_REVISION = 17;
+ public static final int LATEST_REVISION = 20;
private final Application mContext;