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