[sqlite] System.Data.SQLite 1.0.97 on Win10

[Jan Leimbach]

Hi everyone,

I try to update a table in my sqlite database and get "Not an error" result
from the SQLite engine. The same query works on win7. I know that win10 is
not final released yet, but I have no clue wants going wrong here.

I created a simple test statement like UPDATE tablename SET field = '123'
WHERE field = '321'
It returns always "Not an error" and does not update the table.

The simple code is like this:


            SQLiteConnection connection = new SQLiteConnection();
            connection.ConnectionString = "Data Source=" + sourceDb;
            connection.Open();
            SQLiteCommand command = new SQLiteCommand(connection);
            command.CommandText = "UPDATE daten SET einrichtungs_kz =
'WL10022093' WHERE einrichtungs_kz LIKE '%20II%'";
            command.ExecuteNonQuery();
            connection.Close();

Can someone give me a hint?
Thanks!
Jan