I posted this earlier in the week and didn't get a resolution. Can anyone help out?
------- Using the latest SQLite Version can you do: select clma from tablea; while( sqlite3_step() ) { somevalue = sqlite3_column_int( clma ); if ( somefunction( somevalue ) == true ) delete from tablea clma=somevalue; else process_row_as_required; } 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