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

2008-03-25 Thread Igor Tandetnik
"Severin Müller" <[EMAIL PROTECTED]> wrote: > 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; >

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

2008-03-25 Thread Clark Christensen
, it looks like you skip every odd row by calling step(oStmt) in the while condition, and then again inside the block. -Clark - Original Message From: Severin Müller <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, March 25, 2008 2:14:33 PM Subject: [sqlite] [C] Getting r

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

2008-03-25 Thread 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),,NULL)==SQLITE_OK) {