Rich, just a performance note, try the following logic: sqlite3_exec(db, "BEGIN IMMEDIATE", NULL, NULL, NULL); sqlite3_prepare(db, "INSERT INTO table1 (blobData) VALUES (?1)", -1, &stmt, NULL); -For each blob... sqlite3_bind_blob(stmt, 1, blobData, blobSize, SQLITE_TRANSIENT); sqlite3_step(stmt); // with appropriate error checking sqlite3_reset(stmt); -end for each. sqlite3_finalize(stmt); sqlite3_exec(db, "COMMIT", NULL, NULL, NULL);
Rich Rattanni <[EMAIL PROTECTED]> wrote: I wish I could run valgrind, but this project is running on an ARM chip and there is no port for the ARM last I checked. Thanks for checking my code. -- Rich Rattanni On 7/2/07, [EMAIL PROTECTED] wrote: > "Rich Rattanni" wrote: > > > > sqlite3_exec(db, "BEGIN IMMEDIATE", NULL, NULL, NULL); > > -For each blob... > > sqlite3_prepare(db, "INSERT INTO table1 (blobData) VALUES (?1)", -1, > > &stmt, NULL); > > sqlite3_bind_blob(stmt, 1, blobData, blobSize, SQLITE_TRANSIENT); > > sqlite3_step(stmt); // with appropriate error checking > > sqlite3_finalize(stmt); > > -end for each. > > sqlite3_exec(db, "COMMIT", NULL, NULL, NULL); > > > > The above is correct and should work fine. > > -- > D. Richard Hipp > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------