Re: [sqlite] sqlite insert and delete statements not succeed
hi, Doug, Thanks for your reply, I have just fixed that bug, the issue caused by not closing database correctly, so next time I opened the database, all things rolling back. Thanks for your patience and passion. best regards On Thu, 2008-11-13 at 09:48 -0500, Doug Currie wrote: > On Nov 12, 2008, at 10:31 PM, henry wrote: > > > my app, I opened a database handler, insert some records, delete some > > records, then closed the database handler. The problem is the next > > time > > when I connect the Sqlite, the actions I did last time has all gone > > away, it did not take any effect to the database. There's no error > > code > > when using the sqlite api, and if I use that handler to query the > > database, the inserted data is there. > > What filename did you give to sqlite3_open? > > Do you see that file being created by your app? > > Is it modified (does the file modified time or size change) when your > app runs? > > e > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite insert and delete statements not succeed
On Nov 12, 2008, at 10:31 PM, henry wrote: > my app, I opened a database handler, insert some records, delete some > records, then closed the database handler. The problem is the next > time > when I connect the Sqlite, the actions I did last time has all gone > away, it did not take any effect to the database. There's no error > code > when using the sqlite api, and if I use that handler to query the > database, the inserted data is there. What filename did you give to sqlite3_open? Do you see that file being created by your app? Is it modified (does the file modified time or size change) when your app runs? e ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite insert and delete statements not succeed
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 henry wrote: > The problem is the next time > when I connect the Sqlite, the actions I did last time has all gone > away, it did not take any effect to the database. There's no error code > when using the sqlite api, and if I use that handler to query the > database, the inserted data is there. What are you using to access the SQLite api? The above cannot happen if you are using the C api directly. If you are using another programming language and wrapper then it is possible the wrapper is managing transactions behind your back. Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkbvW4ACgkQmOOfHg372QQdWQCfUNavXIkHP6a7GWcgmQMFOiLZ YT0AoIQH7KWg/clSlxjlkuKUlhuTGsO9 =S24q -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite insert and delete statements not succeed
Hi P Kishor, I dont use transactions, and I dont commit. Do I have to commit even if I dont use transactions? BTW, my sqlite version is 3.4.0 Thanks for your reply On Wed, 2008-11-12 at 21:48 -0600, P Kishor wrote: > On 11/12/08, henry <[EMAIL PROTECTED]> wrote: > > hey, > > I'm a rookie to SQLITE, recently I tried to use Sqlite to integrate with > > my app, I opened a database handler, insert some records, delete some > > records, then closed the database handler. The problem is the next time > > when I connect the Sqlite, the actions I did last time has all gone > > away, it did not take any effect to the database. There's no error code > > when using the sqlite api, and if I use that handler to query the > > database, the inserted data is there. > > > > Is your application using transactions? Did you forget to commit? > > > > Thanks in advance > > regards > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite insert and delete statements not succeed
On 11/12/08, henry <[EMAIL PROTECTED]> wrote: > hey, > I'm a rookie to SQLITE, recently I tried to use Sqlite to integrate with > my app, I opened a database handler, insert some records, delete some > records, then closed the database handler. The problem is the next time > when I connect the Sqlite, the actions I did last time has all gone > away, it did not take any effect to the database. There's no error code > when using the sqlite api, and if I use that handler to query the > database, the inserted data is there. > Is your application using transactions? Did you forget to commit? > Thanks in advance > regards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite insert and delete statements not succeed
hey, I'm a rookie to SQLITE, recently I tried to use Sqlite to integrate with my app, I opened a database handler, insert some records, delete some records, then closed the database handler. The problem is the next time when I connect the Sqlite, the actions I did last time has all gone away, it did not take any effect to the database. There's no error code when using the sqlite api, and if I use that handler to query the database, the inserted data is there. Thanks in advance regards ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users