SQLITE - INSERT does not return error but no data is inserted.
Posted
by Nick
on Stack Overflow
See other posts from Stack Overflow
or by Nick
Published on 2010-06-14T20:45:34Z
Indexed on
2010/06/14
20:52 UTC
Read the original article
Hit count: 179
I am attempting to insert data into a local SQLITE database file from a C# application. The transaction does not throw any errors but the data is not inserted. The same insert statement works from within a query analyzer.
Do I need to perform a commit? Is there a Commit method?
Command's transaction property is null..
var command = new SQLiteCommand(insert.BuildInsert(tableName,keyValuePairs),Connection);
command.ExecuteNonQuery();
© Stack Overflow or respective owner