PSEAD Member Licensed User Longtime User Jan 18, 2018 #1 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.
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 B4X founder Staff member Licensed User Longtime User Jan 18, 2018 #2 Set it in the SQL command directly. Code: Copy SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(null, ?)", Array(other value here)) Upvote 0
Set it in the SQL command directly. Code: Copy SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(null, ?)", Array(other value here))