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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to