There must be something really simple that I am missing, but could someone tell me why I am getting a DatabaseException with this code:
Private Sub SaveEmailRecord(subject As String, body As String, recipients() As String) 'TABLE EmailRecords 'Email_ID 'Recipients 'Subject 'Body 'SentDate Var sql As String sql = "INSERT INTO EmailRecords(Recipients,Subject,Body,SentDate) VALUES(?,?,?,?)" Var recipientlist As String = String.FromArray(recipients, ", ") 'MainDatabase is a connected SQLiteDatabase 'recipientlist has the value "Frank Sun <firstname.lastname@example.org>" MainDatabase.ExecuteSQL(recipientlist, subject, body, DateTime.Now.SQLDate) End Sub
On the ExecuteSQL line a DatabaseException occurs with
Message: near “Frank”: syntax error
According to sqlite.org, error code 1 is SQLITE_ERROR /* Generic error */
Someone please point out what silly mistake I have made!