On 12/05/2009 9:30 AM, John Machin wrote: > 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?
See also this rather long thread with no conclusion: http://www.lfsforum.net/showthread.php?t=40984 The starter of that thread mentioned that he was getting an error; are you sure that you are not suppressing exceptions? Are you doing the UPDATE with the ExecuteDML method or one of the "execute query" methods? Is it possible for you to post the minimum program that you assert should work, but doesn't work? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users