Hi Neville,
> 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?
Is there any reason why you don't simply let SQL do the work for you:
delete from TableA where Clma == somevalue;
then process (the remaining) rows
Tom
BareFeet
http://www.tandb.com.au/sqlite/compare/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
