"hussainfarzana" <[email protected]> wrote in message news:[email protected] > 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.
Can you show a small complete code sample that reproduces the problem? Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
