I have some code that i'm having problems with. i open the database,
prepare, and the step through. During each step i'm trying to run a
seperate exec which is attempting to update a row. I keep getting a error
that says database is locked. I tried creating a additional open to just
use on the updates but i get the same error. Short example below with no
error checking.
sqlite3_open("my.db", &db);
sqlite3_prepare(db, "SELECT ip_address FROM ips WHERE ip_owner=''",
&plineInfo, 0);
while(sqlite3_prep(plineInfo) == SQLITE_ROW) {
zSQL = sqlite3_mprintf("UPDATE ips set ip_owner='%q' WHERE ip_owner=''
and ip_address='%q'", username, sqlite3_column_text(plineInfo, 0));
sqlite3_exec(db, zSQL, 0, 0, 0) == SQLITE_OK);
}
Agian this is just a quick/basic example showing what i'm trying to do. I
keep getting database is locked when checking the error returned by exec.
~Shaun
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
