Sorry, I forgot to give you a snip of the test-bench code

getter() {
    string sName;
    string sAddress;
    int age = 0;
    string dbdata = "SELECT * FROM friend";

    rc = sqlite3_prepare_v2(db, dbdata.c_str(), -1, &stmt, NULL );
    ....
    rc = sqlite3_step(stmt);
    if(rc != SQLITE_DONE) { ... }
    while ( sqlite3_step(stmt) != SQLITE_ROW)  {
        sName = (char*)sqlite3_column_text(stmt, 0); //<== Seg fault
        std::cout << sName << std::endl;
    ...
    }
    sqlite3_finalize(stmt);
}



-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: Monday, June 25, 2012 9:07 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] C++ programming - creating a table

Arbol One <arbol...@gmail.com> wrote:
> Q: What are you trying to achieve here? What's the supposed purpose of 
> sqlite3_column_type call?
> 
> A: What I am trying to do is to display the data in a data table

You run a SELECT statement for that. In any case, what data do you expect
there to be right after CREATE TABLE?
--
Igor Tandetnik

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

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

Reply via email to