On Mon, Mar 31, 2014 at 7:33 AM, d b <va230...@gmail.com> wrote:
> My application calls sqlite3_finalize() after insertion of 10,000
> record(loop). Is there any other reason?
>
You might have failed to call sqlite3_reset(), or you might have called
sqlite3_step() after the previous sqlite3_reset() but before the
sqlite3_bind_text().
>
>
> On Mon, Mar 31, 2014 at 3:23 PM, d b <va230...@gmail.com> wrote:
>
> > sqlite3_bind_text() returned 21 error. It is throwing for all insertions
> > once error introduced.
> >
> > For ex: Here, Inserted first 10 records successfully. then it was started
> > throwing error 21 for 11th record on-wards till last record(10,000
> record).
> > I was able to insert the records successfully after restart the
> application
> > only.
> >
> >
> > On Mon, Mar 31, 2014 at 2:23 PM, d b <va230...@gmail.com> wrote:
> >
> >> Hi,
> >>
> >> I am getting sqlite error 21.
> >>
> >>
> >> There is only one sqlite prepared statement for insertion. It's not
> >> multi threaded app. The below function repeatedly calling for every
> record
> >> insertion. This app was running from last 4 days. On third, it was
> started
> >> throwing error 21. What could be the reason?
> >>
> >> steps from application:
> >>
> >> bool stmt::execute(const char* const insertquery, listofinputparams)
> >> {
> >>
> >> insertquery is insert or replace into mystuff(id, name, value)
> >> values(?,?,?);
> >>
> >> bool r = false;
> >>
> >> sqlite3_stmt s = find(insertquery);
> >>
> >> while(enumerate listofinputparams)
> >> {
> >> bind each argument for insert statement s
> >> }
> >>
> >> sqlite3_step(s);
> >>
> >> sqlite3_reset(s);
> >>
> >> return r;
> >> }
> >>
> >> Thanks,
> >> a v
> >>
> >
> >
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
