Thank you, Thomas. I used a temporary table, and now it works. However, it seems that my code worked with sqlite 2. Can this be?
Martin
Thomas Fjellstrom schrieb:
On May 12, 2005 04:59 am, Martin Engelschalk wrote:
Hello,
i open cursor on a table and retrieve rows from it. For every row i decide whether to update it. However, when executing the update I get the error "database table is locked". My application is the only one working on the table. Is it illegal to update a table while selecting from it or am i doing somethin wrong?
Thanks,
Martin
Yup. you'll have to scan for updates to make, then after the scan, make the updates.
