[sqlite] Use of sqlite3_step()

[Andrew Wood]

Whats the procedure for using sqlite3_step?

I thought it would be along the lines of the following, but the while 
loop executes infinately. I would have expected the while loop to run 
once for each row found?

Code is as follows:

int queryreturn = sqlite3_step(preparedstatement);

if (queryreturn == SQLITE_DONE)
     {
         //no rows found
         return;

     }
     else if (queryreturn == SQLITE_ROW)
     {
         //row found, will process in a sec
     }
     else
     {
         //error, throw exception

     }
     //if we get here we have 1 or more rows to process

     while (queryreturn==SQLITE_ROW)
     {    //process row
         printf("row found\n");

         //advance to next row
         int queryreturn = sqlite3_step(preparedstatement);
     }
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users