"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;
> if(sqlite3_prepare_v2(db,buf,strlen(buf),&oStmt,NULL)==SQLITE_OK)
You are using uninitialized db variable. You need to open the database
connection first with sqlite3_open.
> {
> while(sqlite3_step(oStmt)==SQLITE_ROW)
> {
> sqlite3_step(oStmt);
You call sqlite3_step twice on every iteration. Which means you only
look at every other row.
> txt = (char*)sqlite3_column_text(oStmt,0);
txt is never declared.
> sqlite3_reset(oStmt);
> sqlite3_finalize(oStmt);
> sqlite3_close(db);
You finalize the statement and close the databse after reading just one
row. Don't you want to enumerate all rows?
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
