Thanks for your reply Igor. We checked and we have commited the transaction.
Below is the query we used where all the fields are numeric and it is prepared once: INSERT INTO ShopDataNum values(?,?,?,?,?,?,?,?,?,?,?) When we bind the values the steps were returning the correct value but the record is not found in the DB. Then we tried by passing the static value for the first field in sqlite3_prepare and we bind the values. INSERT INTO ShopDataNum values(9600000002,?,?,?,?,?,?,?,?,?,?) The steps were executed correctly and the record is inserted correctly in the DB. Again we tried the first query and assigned the static value for the first field while binding the values, the steps were executed correctly but the record is not found in the DB. Please guide us how to proceed further. Thanks and Regards, Farzana. Igor Tandetnik wrote: > > "hussainfarzana" > <hussainfarz...@gmail.com> wrote in > message news:21849799.p...@talk.nabble.com >> 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. > > Do you, by any chance, start a transaction and then forget to commit it? > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Insertion-and-Updation-using-sqlite3_prepare%28%29-tp21849799p21866676.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
