Problems when I try to see databases in SQLite
- by Sabau Andreea
I created in code a database and two tables:
static final String dbName="graficeCirculatie";
static final String ruteTable="Rute";
static final String colRuteId="RutaID";
static final String colRuta="Ruta";
static final String statiaTable="Statia";
static final String colStatiaID="StatiaID";
static final String colIdRuta="IdRuta";
static final String colStatia="Statia";
public DatabaseHelper(Context context) {
super(context, dbName, null,33);
}
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("CREATE TABLE " + statiaTable + " (" + colStatiaID + " INTEGER PRIMARY KEY , " +
colIdRuta + " INTEGER, " + colStatia + " TEXT)");
db.execSQL("CREATE TABLE " + ruteTable + "(" + colRuteId + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
colRuta + " TEXT);");
InsertDepts(db);
}
void InsertDepts(SQLiteDatabase db)
{
ContentValues cv = new ContentValues();
cv.put(colRuteId, 1);
cv.put(colRuta, "Expres8");
db.insert(ruteTable, colRuteId, cv);
cv.put(colRuteId, 2);
cv.put(colRuta, "Expres2");
db.insert(ruteTable, colRuteId, cv);
cv.put(colRuteId, 3);
cv.put(colRuta, "Expres3");
db.insert(ruteTable, colRuteId, cv);
}
Now I want to see tables inputs from command line.
I try in this way:
C:\Program Files\Android\android-sdk\tools sqlite3
SQLite version 3.7.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite sqlite3 graficeCirculatie
... select * from ruteTable;
And I got an error:
Error: near "squlite3": syntax error.
Can someone help me?
