Can I do an Update while stepping through a prepared query?
example in psuedo code:
---
compile( "select rowid, tag, expanded from tags order by tag;"
sqlite3_step();
do
{
if ( some_clm == some_value )
sqlite3_exec( "update tags set expanded=%d where rowid=%Q;",
.. );
// will the subsequent sqlite3_step() calls perform as
expected?
}
while( sqlite3_step() == SQLITE_ROW );
-----
--
Best regards,
Neville Franks, http://www.surfulater.com http://blog.surfulater.com
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users