Hi Tom,
Monday, April 21, 2008, 10:05:04 AM, you wrote:
B> 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?
B> Is there any reason why you don't simply let SQL do the work for you:
B> delete from TableA where Clma == somevalue;
B> then process (the remaining) rows
Tom, the example I gave of
if ( clma == somevalue )
was a bad one. I actually need to call a function for each iteration
of sqlite3_step() and depending on what it returns, delete the row or
not.
--
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
