lilezek wrote: > Hi. I'm using SQLite in my own c++ aplication. Everything works except if I > try to do this query: > > UPDATE rnc_accounts SET lastip = '127.0.0.1' WHERE name = 'lilezek'; > > But when I do step I got always 5 (SQLITE_BUSY). You'll think the problem is > mine, but I change the query to the next one: > > SELECT * FROM rnc_accounts WHERE name = 'lilezek'; > > And it works fine. Any idea?
There's a reading transaction open on a different connection to the same database. Two reading statements can execute in parallel (that's why SELECT works) but reading and writing can't (that's why UPDATE doesn't). Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users