[sqlite] sqlite3_step and column name

[Shaun R.]

I'm trying to understand a bit how this works.  For my example i just simply 
want to set a column value to a char.  If i know the name of the column how 
can id o this.  For example the column name i want is 'fname'.  I know the 
section below with setting myname and then printing it doesnt really make 
sense since i could do both of these in one line, just doing that to get  a 
idea.  The `myname = plineInfo[fname];` i'm sure is wrong, it's just there 
to give you guys a idea of what i'm trying to get.  Were am i going wrong 
here?


int main(void)
{
   char myname[50];
   sqlite3 *db;
   sqlite3_stmt *plineInfo = 0;

   if(sqlite3_open("my.db", &db) != SQLITE_OK) {
      return 0;
   }

   if(sqlite3_prepare(db, "SELECT * FROM mytable", -1, &plineInfo, 0) != 
SQLITE_OK) {
      return 0;
   }

   while((rc = sqlite3_step(plineInfo)) == SQLITE_ROW) {
       /* i know this doesnt make much sense to do but it's only a test */
      myname = plineInfo[fname];
      printf("fname column was set to %s\n", myname);
   }

   sqlite3_finalize(plineInfo);

   sqlite3_close(db);

   return 1;
}



~Shaun



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users