On 12/05/2009 8:31 AM, manp wrote: > when i execute a query like this > UPDATE setting SET value="red" WHERE name="color" > the row will update temporary while app is running , when i close app noting > appear in DB > i use ManagedSQLite dll
I presume that you refer to this: http://code.google.com/p/managed-sqlite/ Have you tried calling the CommitTransaction method or the EndTransaction method? Have you noticed that somebody asked what was the difference between those two methods about 5 months ago, with no response? Have you noticed that the project was created in June 2007 and appears not to have been updated since? Perhaps other users of SQLite / C# / .NET might like to recommend an alternative interface to you. HTH, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users