SQLite database table is locked error

[elck]

SQLite "database table is locked" error

1. Is there a better place to ask this question?
2. If not:

I read that reading and writing in a sqlite table cannot be done 'at the same time' and that is why I get this error.

My code goes something like this:

$query="SELECT * FROM (bestanden) WHERE naam='$basename'  ORDER BY naam ;";
$result=$sql->unbufferedQuery($query);
$row=$result->fetch(SQLITE_ASSOC);

[...]

$query4="UPDATE bestanden SET datum='$fd' WHERE naam='$basename' ";
$result4=$sql->query($query4);

How would I avoid the error?

 

[jpadie]

use fetchAll rather than fetch. this is an ok methodology unless your recordset is likely to be very large.

 

[DonQuichote]

Could the unbuffered query be the problem? If trhe query results would be buffered, the query itself could be closed again.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[elck]

Thanks both of you.'ll try this tomorrow.
The recordset is rather largish, this why I opted for unbuffered, but if this solves my problem, I think I can handle the extra data, or maybe limit it in an other way, Thanks again, I'll let you know if it worked.

 

[jpadie]

there's no way around this. it's a file lock issue. you must release the read lock created by the select query before you engage the write lock.