jeudi 26 novembre 2015

Android insert date to database datePicker error

I'm currently working on Android studio and trying to insert a date (using a DatePickerFragment) in a local DataBase but I keep on getting an error that the column doesn't exist. I'm a bit of a noob so please be gentle :)

android.database.sqlite.SQLiteException: no such column: date (code 1): , while compiling: SELECT nome, descricao, date FROM exames

I have the DatePickerFragment Class:

public class DatePickerFragment extends DialogFragment implements DatePickerDialog.OnDateSetListener {

private Calendar dateTime=Calendar.getInstance();

@Override
public Dialog onCreateDialog(Bundle savedInstanceState) {
    // Use the current date as the default date in the picker
    final Calendar c = Calendar.getInstance();
    int year = c.get(Calendar.YEAR);
    int month = c.get(Calendar.MONTH);
    int day = c.get(Calendar.DAY_OF_MONTH);

    // Create a new instance of DatePickerDialog and return it
    return new DatePickerDialog(getActivity(), this, year, month, day);
}

public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {
    // Do something with the date chosen by the user
    TextView et1= (TextView) getActivity().findViewById(R.id.theDateET);
    et1.setText("Year: " + view.getYear() + " Month: " + view.getMonth() + " Day: " + view.getDayOfMonth());




    dateTime.set(year,monthOfYear,dayOfMonth);

    int mYear = year;   // Here you can get day,month and year.
    int mMonth = monthOfYear +1;
    int mDay = dayOfMonth;

    ContentValues values = new ContentValues();

    values.put("date",mDay + mMonth + mYear);
   /* values.put("Month",mMonth);
    values.put("Year", mYear);*/

     }
}

And in my InsertActivity I call this method:

 public void showDatePickerDialog(View v) {
    DialogFragment newFragment = new DatePickerFragment();
    newFragment.show(getSupportFragmentManager(), "datePicker");
}

Also in my DataBaseAdapter Class I have this function to insert in the DB

 public long insertExame(String oNome, String aDescricao, String date) {
    ContentValues values = new ContentValues();
    values.put("nome", oNome);
    values.put("descricao", aDescricao);
    values.put("date", date);
   /* values.put("month", month);
    values.put("day", day);*/

    return database.insert("exames", null, values);
}

EDIT: Here is where I create my DataBase:

public class HelpDataBase01 extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "base-dados.db";
private static final int VERSION = 1;
public HelpDataBase01(Context context){
    super(context, DATABASE_NAME, null, VERSION);
}
@Override
public void onCreate(SQLiteDatabase db){
    db.execSQL("CREATE TABLE exames(_id integer primary key autoincrement, nome varchar(40), descricao varchar(40), date varchar(100))");

}
@Override
public void onUpgrade (SQLiteDatabase db, int oldVersion, int newVersion){
    db.execSQL("DROP TABLE IF EXISTS Exames");
    onCreate(db);

}

}

Thanks for the help!

Aucun commentaire:

Enregistrer un commentaire