On Dec 31, 2004, at 9:11 AM, Thomas Fjellstrom wrote:
On December 31, 2004 06:37 am, D. Richard Hipp wrote:
Even in version 3.0.8, if you have a query running on a table
that has not yet returned SQLITE_DONE, then you are prohibited
from making changes to that table.
So something as simple as: (riped out of delete_key())
Yes, it does fail, and I just ran into this in some code I was writing.
It's a pain -- I'm having to do a bunch of extra data buffering to get
around this. Is this common with SQL? I hadn't run into it with MySQL.
-jdb
MadSQLiteResult *res = conf->db->preparef("SELECT id FROM conf_key
WHERE parent_id=%i;", kid);
if(!res)
return false; while(res->step() == MadDB_ROW) {
if(!delete_key(res->columnInt(0)))
return false;
}
delete res;
conf->db->queryf("DELETE FROM conf_key WHERE id=%i", kid);
will fail? :(
Thanks, and sorry for the half written duplicate :(
-- Thomas Fjellstrom
[EMAIL PROTECTED]
http://strangesoft.net
