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