lundi 14 décembre 2015

Multiple Table SQlite DB [duplicate]

This question already has an answer here:

I need to add multiple Table but when i insert basket table i get "no such table: BASKET (code 1):" Error

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseClass extends SQLiteOpenHelper {
    static final String Database1="STUDENT_DB";
    enter code here
    static final int version=1;
    public DatabaseClass(Context ctxt){
        super(ctxt, Database1, null, version);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE STU_TABLE (id INTEGER PRIMARY KEY AUTOINCREMENT , name TEXT, surname TEXT, sid TEXT, mail TEXT);");
        db.execSQL("CREATE TABLE BASKET (id INTEGER PRIMARY KEY AUTOINCREMENT ,  ProductName TEXT, value TEXT , date TEXT);");
    }


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

Aucun commentaire:

Enregistrer un commentaire