From the documentation and this post I know execSQL()
executes a single SQL statement that is not a SELECT
or any other SQL statement that returns data. It is also mentioned that execSQL()
should not be used for inserting.
But I'm using execSQL()
for inserting like:
db.execSQL("INSERT INTO LIST VALUES('???');"); //where LIST is a table
This is working perfectly for me (there is no SELECT
statement with this INSERT
), but I was told not to use this here.
So, my question is: does the INSERT
statement return a value even though there is no SELECT
statement attached to it?