Hello, I have just worked through a similar situation. SQLITE would work correctly for selects but would return SQLITE_DONE when selecting but the record would not get updated when doing an update. To confuse matters more I could update the record with no problems when using Firefox SQLITE manager and if I then selected the record I would see the update which made me believe that I was referencing the same db file in all cases. I am doing iphone development and was working with the simulator and xcode. Xcode was actually taking my original database file and burying it in the sand box every time I ran the application so I saw the updates that the management interface was making but the updates that I was making programmatically were failing without a whimper from SQLITE. I found that the reason for the failure was because of file permisions on the db file in the sandbox which had only read access. I finally wrote the commrands necessary to create the database programmatically and set the permissions on the file to allow write access. This did resolve my problem.
Regards, -Tom On Thu, Feb 5, 2009 at 4:42 AM, hussainfarzana <hussainfarz...@gmail.com>wrote: > > Dear All, > > We are using SQLite version 3.6.10. > > We are using the sqlite3_prepare() and sqlite3_bind() methods for insertion > and updation of the records in the database.Everything works fine and > sqlite3_step() returns 101 which is SQLITE_DONE.When we check the DB, the > records are not inserted. > > Please help us in this regard. > > Thanks and Regards, > Farzana. > -- > View this message in context: > http://www.nabble.com/Insertion-and-Updation-using-sqlite3_prepare%28%29-tp21849799p21849799.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > 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
