Use the latest SQLite Version can you do: select clma from tablea; while( sqlite3_step() ) { if ( clma == somevalue ) delete from tablea clma=somevalue; else process row; }
ie. Delete a row while stepping through the results of a select and know the remaining sqlite3_step()'s will work correctly? -- 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