Android Question How do I set a sqlite field to null using the Smart String Literal ?

[PSEAD]

How do I set a sqlite field to null using the Smart String Literal when the string variable is ""? (using ${variable})
I have tried various options and I get "" or "null" as strings when writing to the database. i.e. Smart string needs to change "" to null.

 

[Erel]

Set it in the SQL command directly.

SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(null, ?)", Array(other value here))