Hello, I'm experiencing a strange problem with SQLite when trying to retrieve a large BLOB field.
I have a table with two columns. One is an ID field and is the key. The second is a BLOB field. The table contains several hundred rows and some of the BLOB fields are 10+MB in size. Everything works fine until I try to do multiple retrievals in a short span of time. If I do each row with the ID slowly (as slowly as a user would click), I get the BLOB field fine. However, if I try to go through them quickly then I seem to have problems with some of the larger BLOB fields. The query is is returning true for isNull() on the BLOB column. It doesn't matter if I select them individually with the key, or if I just go through them all at once with the "SELECT blobfield from table" and just do a next() to iterate over the values. I've tried recreating the QSqlQuery multiple ways but can't get around the problem. The database is returning this as an error: QSqlError(-1, "Unable to commit transaction", "cannot commit - no transaction is active") Has anyone come across this problem and am I doing something wrong? Thanks, Randy
_______________________________________________ Qt-jambi-interest mailing list [email protected] http://lists.trolltech.com/mailman/listinfo/qt-jambi-interest
