[sqlite] [C] Getting results doesn't work properly

[Severin Müller]

Hi Folks

I have the following C funtion:

void get_acc(char *src,int ac,char **av)
{
       char *buf = "SELECT accmask FROM testtable;");
        sqlite3 *db;
        struct sqlite3_stmt *oStmt;
        int rc; 
        if(sqlite3_prepare_v2(db,buf,strlen(buf),&oStmt,NULL)==SQLITE_OK)
        {
                while(sqlite3_step(oStmt)==SQLITE_ROW)
                {
                        sqlite3_step(oStmt);
                        txt = (char*)sqlite3_column_text(oStmt,0);
                        sqlite3_reset(oStmt);
                        sqlite3_finalize(oStmt);
                        sqlite3_close(db);
                        printf("Result: %s\n",txt);
                }
        }
 }

If i call the function, only one row is returned, but there are definately more 
(i check with SELECT COUNT(*)). Did i oversee something? Or what's wrong here?

Thanks again for your help.

Kind regards

Severin
-- 



Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users