How to use rawQuery() method to insert a record?

Question

I need to store a record using rawQuery() method, because I want to insert the current date and time (datetime()), but I also need to insert strings that contain quotes.

So I wrote this code:

String sql="INSERT INTO sms VALUES ( null, ?1, ?2, ?3, datetime())";
dbw.rawQuery(sql, new String[]{str1,str2,str3});

But it doesn't store anything... what's wrong?

[EDIT]

In this way I don't get errors, but the record is not inserted.

String mitt="mitt", dest="dest", text="text";
String sql="INSERT INTO sms VALUES ( null, ?, ?, ?, datetime('NOW'))";
dbw.rawQuery(sql, new String[]{mitt,dest,text});

At this moment, the only method that works to insert a record (with quotes problem) is execSQL(String s).

Answer 1

SQLite doesn't have a native datetime data storage type. It can store a string or an integer representation of a date instead.

To convert your values you can use the date time functions detailed in Sqlite Date and Time functions documentation

Your initial attempt is almost correct, but your datetime() function call requires an argument of 'NOW'.

String sql="INSERT INTO sms VALUES ( null, ?, ?, ?, datetime('NOW'))";

Also you should call execSQL instead of rawQuery which is expecting to return a recordset.

dbw.execSQL(sql, new String[]{str1,str2,str3});

You can alo specify individual columns to insert data into by inserting a field list after the table name in your query if not inserting all the values

String sql = "INSERT INTO sms(f1, f2, f3, f4)"
           + "VALUES ( null, ?, ?, ?, datetime('NOW'))";

Another option that may be possible is using a default timestamp in SQLite ,although I have not attempted this in android.

Answer 2

I solved the problem with in this way:

String sql="INSERT INTO sms VALUES (null,?,?,?,datetime('NOW'))";
dbw.execSQL(sql,new Object[]{mitt,dest,text});

Finally I can store every char without problems!!!