On Feb 8, 2009, at 2:55 AM, Tom Longbotham wrote: > 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.
Could be a bug. Operating system? Exactly how do we set the permissions on the database file to cause the problem? Dan. > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users