[sqlite] sqlite suddenly thrown error

[d b]

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