Why doesn't this work??
db.execSQL("INSERT INTO PARTIES (PARTY_NAME, PARTY_COUNT) SELECT DISTINCT(PARTY), COUNT(PARTY) FROM ? WHERE (Year=?) GROUP BY PARTY ORDER BY PARTY ASC", new Object[] { "Election", "2004" });
It works perfectly in rawQuery!!
-
I've never seen a table name be passed as a parameter before. But maybe I just never tried... Parameters are typically used to allow reuse of the same query plan. So you can just provide a different value filter on each run. In your case, why would the table be dynamic?beach– beach2010-02-17 05:10:28 +00:00Commented Feb 17, 2010 at 5:10
Add a comment
|
2 Answers
I don't know what "rawQuery" you're referring to (URL please). I don't know of any SQL engine which allows parameter substitution for metadata such as names of tables and columns -- only values, nor names, are allowed in parameter substitution. SQLite is no exception.
2 Comments
Jeremy Logan
He's talking about the
rawQuery() method on the SQLiteDatabase object: developer.android.com/reference/android/database/sqlite/…
Alex Martelli
@fiXedd, tx -- the discussion on the other "answer" makes more sense now;-).
May be it should not?
copypaste from doc:
public void execSQL (String sql, Object[] bindArgs)
Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.
For INSERT statements, use any of the following instead.
insert(String, String, ContentValues)insertOrThrow(String, String, ContentValues)insertWithOnConflict(String, String, ContentValues,int)
http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html
