On Sat, Mar 15, 2008 at 10:18 PM, danjenkins <[EMAIL PROTECTED]> wrote:
>
> 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();
> }
>
> fclose(fp);
> sqlite3_close(pDB);
>
> I'd really appreciate a couple of tips so I can get back on track with my
> project.
Not without digging through the internals. You might be interested in
Berkeley DB.
--
Cory Nelson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
