Udv SQLite-al kinlodok, sehogy sem tudom feltolteni adattal, sot beszurni sem. Itt all meg az app:
sqlite returned: error code = 1, msg = near "TABLEpatients": syntax error, db=/data/data/com.dicom/databases/patientManager
Ez a create:
public void onCreate(SQLiteDatabase db) {
String CREATE_TABLE = "CREATE TABLE" + TABLE_PATIENT + "("
+ KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
+ KEY_BDAY + " TEXT," + KEY_AGE + " TEXT,"
+ KEY_FILE + " TEXT" + ")";
db.execSQL(CREATE_TABLE);
}
ez az insert:
public void addPatient(Patient contact) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_NAME, contact.getName());// Name
values.put(KEY_BDAY, contact.getBday());
values.put(KEY_AGE, contact.getAge());
values.put(KEY_FILE, contact.getFile());
// Inserting Row
db.insert(TABLE_PATIENT, null, values);
db.close(); // Closing database connection
}
Három dolog biztos az életben: az adó, a halál és az adatvesztés. - Baráth Gábor