Hello,

how to process if the select-statement selects a column with NULL  ?


==========================================
char *mydetails;
char *sql;
sqlite3_stmt *stmt;
sqlite3 *db;
const char dbname[] = "mysqlite.db";


sql = "Select mydetails from mytable";

rc = sqlite3_prepare(db, sql, strlen(sql), &stmt, NULL);

rc = sqlite3_step(stmt);


while(rc == SQLITE_ROW) {

    // here maybe NULL is returned ?
    mydetails = (char*)sqlite3_column_text(stmt, 0 );
    rc = sqlite3_step(stmt);
}
=======================================
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to