Re: [sqlite] Reading error outside the while

[[EMAIL PROTECTED]]

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: Hello,

I got an error when I try to read some data outside the while{}, inside the 
while{} it's ok, an idea ?
test.db have just one "table1" and a "field1" with values "one", "two", "three".

#include #include

int main(void)
{
    sqlite3 *db;
    sqlite3_stmt *pStat;

    const char *dbname = "test.db";
    const char *sql = "SELECT * FROM table1";
    const unsigned char *my_array[3];
    int i=0;;

sqlite3_open(dbname, &db);

    sqlite3_prepare_v2(db, sql, -1, &pStat, 0);

while(sqlite3_step(pStat) == SQLITE_ROW)

    {
 my_array[i] = sqlite3_column_text(pStat, 0);
     printf ("%s\n",my_array[i]); // ok

 i++;
    }

    for (i = 0; i<3; i++);{
 printf ("%s\n", my_array[i]); // error
    }

sqlite3_finalize(pStat);

    sqlite3_close(db);

return 0;

}


Fred.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Ken a écrit :

You need to make a copy of the str instead of just capturing a pointer 
reference.

try:
      my_array[i] = strdup(sqlite3_column_text(pStat, 0));

Its same with strdup()


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------