nD5GQ5SP

1Database doesn't get created
2SQLiteDatabase db = openOrCreateDatabase("mydata.db",SQLiteDatabase.CREATE_IF_NECESSARY,null);
3                    try
4                    {
5                    db.execSQL("CREATE TABLE IF NOT EXISTS vars (id INTEGER PRIMARY KEY ASC, varname,varvalue);");
6                    db.execSQL("INSERT INTO vars (varname,varvalue) VALUES ("user","" + username + "");");
7                    Log.w("Test", "Am executat sql");
8
9                    }
10                    catch (SQLiteException e)
11                    {
12                        Log.w("Exceptie", "Acum or niciodata");
13                    }
14	
15SQLiteDatabase objDb = null;
16        try
17        {
18            objDb =  SQLiteDatabase.openDatabase("mydata.db", null, SQLiteDatabase.OPEN_READWRITE);
19
20        }
21        catch(SQLiteException e)
22        {
23            //addShortcut();//setShortCut(getApplicationContext(),"GpsRo");
24            //setContentView(R.layout.main);
25            Log.w("Exceptie", e.getMessage());
26            showForm = true;
27        }
28	
29SQLiteDatabase db = openOrCreateDatabase(context.getFilesDir()"/mydata.db",SQLiteDatabase.CREATE_IF_NECESSARY,null);
30	
31"CREATE TABLE IF NOT EXISTS vars
32(id INTEGER PRIMARY KEY AUTOINCREMENT,
33varname TEXT,
34varvalue TEXT);"
35	
36db.execSQL("CREATE TABLE IF NOT EXISTS vars (id INTEGER PRIMARY KEY AUTOINCREMENT ASC, varname,varvalue);");
37	
38private DatabaseHelper mDbHelper;
39private SQLiteDatabase mDb;
40private final Context mCtx;
41
42mDbHelper = new DatabaseHelper(mCtx);
43mDb = mDbHelper.getWritableDatabase();