Yes,the SQL prepared statement has got 14 placeholders. The statement is "INSERT INTO CollDataNum values(?,?,?,?,?,?,?,?,'?',?,?,?,?,?)"
Regards, Farzana. SimonDavies wrote: > > 2009/2/2 hussainfarzana <hussainfarz...@gmail.com>: >> >> Dear All, >> >> We are working with SQLite Version 3.6.10. >> We tried to insert or update the records in the database using >> sqlite3_prepare and binding the values using sqlite3_bind functions.We >> have >> started with the index 1.We have a table with 14 columns and when we use >> sqlite3_bind_int,for the first 13 columns its returning 0 and for the >> last >> 14th column which is also an integer datatype, but the function is >> returning >> value 25(SQLITE_RANGE) error. > > Your table may have 14 columns, but has the SQL for your prepared > statement got 14 parameter placeholders? > >> >> Please help us how to proceed further. >> >> Regards, >> Farzana. > > Rgds, > Simon > _______________________________________________ > 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/sqlite3_bind_int-returns-SQLITE_RANGE-tp21788383p21788991.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