"danjenkins" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is it possible to access a table without a SQL query? I've been > searching and haven't found a way. > I'd like to do something like this: > > sqlite3 *pDB = NULL; // database pointer > FILE* fp = fopen("people.db","a+"); > sqlite3_open("people.db",&pDB); > > // Pseudo code that I need help with follows... > while(!pDB->Eof){ > if(pDB->FieldValues["Age"] > 65; > pDB->Edit(); > pDB->FieldValues["Classification"] = "Retired"; > pDB->Post(); > } > pDB->Next(); > }
Why not just run a SQL statement? update tableName set Classification='Retired' where Age > 65; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
