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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
