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

Reply via email to