I prepare the statement once. But I use transaction for every bunch of 500 record inserts.
mikewhit wrote: > > dbikash <[EMAIL PROTECTED]> writes: > >> >> >> Hello, >> ... >> - Thread 1 inserts 500 records to the database every 30 seconds and then >> goes to sleep. (I prepare an insert statement, BEGIN TRANSACTION, bind >> values, step through the statement, reset the statement, and do END >> TRANSACTION) > .... >> This runs ok for some time, but then I get a SQLite error 1 (SQL logic >> error >> or missing database). What could be the problem? > ... >> Thanks in advance for your help. >> dbikash > > Surely your BEGIN TRANSACTION goes /before/ you prepare() the INSERT ? > (Or does it not matter as long as it's before the step() ?) > > Regards, > MikeW > > > > _______________________________________________ > 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/%22SQL-logic-error-or-missing-database%22-with-multithreaded-program-tp20266281p20266828.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
