Could you be omitting the database commit? Try adding an explicit commit after your inserts.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kavita Raghunathan Sent: Tuesday, September 22, 2009 5:59 PM To: sqlite-users Subject: [sqlite] cannot add data to sql tables Hi, I successfully did the following using C wrappers: 1) created a .db file 2) Added the tables 3) Try to insert data into the tables created. When I try to 3) insert data into the tables, all the routines pass (Prepare, Step, Finalize) without errors. But when I run my .db file through sqlite3 shell and select * from EntityTbl(which is the name of my table), nothing shows. Any ideas where my data went ? Kavita _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
