Problems with QSqlQuery update

[jacek]

i use sqlite 3. i also think that select lock the table, i just wanted to be sure that i am not doing something wrong and that this is the correct behaviour of the qt and sqlite.

I don't use SQLite, but probably you can use "PRAGMA read_uncommitted = 1" as a workaround, but beware.

is it possible to do another select statement on the previously locked table but update would not work?

Yes, SELECT acquires a SHARED lock which allows only reading, but UPDATE tries to acquire an EXCLUSIVE lock which can't coexist with any other locks, thus it fails.

[whoops.slo]

thanks, that is what i wanted to know. now everything makes sence and my speculation was correct.