> Also, I have downloaded and installed 'SQLight Designer' and when opening
> the database file, I have just created, all that I can see is the words:
> SQLite format 3.
Apparently you open your database file in some plain text editor
instead of in something that understands what SQLite database is.
Pavel
On Thu, Jun 21, 2012 at 12:22 PM, Arbol One <arbol...@programmer.net> wrote:
> namespace jme {
> class Runner : public Gtk::Window {
> private:
> jme::Exception* e; // Exception handler
> sqlite3 *db; // Data Base
> sqlite3_stmt* stmt; // SQL statement
> Glib::ustring dbName; // db name
> Glib::ustring sName; // my name
> Glib::ustring sAddress; // my address
> Glib::ustring vfs; // MSWIN Identifier
> int rc; // return code
> int age; // my age
> // SQL statement
> Glib::ustring dbdata;
> Glib::ustring create_table;
> public:
> Runner();
> ~Runner();
> void OpenDB();
> void CreateTable();
> void AddData();
> };
> }
> void jme::Runner::CreateTable(){
> rc = sqlite3_prepare_v2(
> db, /* Database handle */
> create_table.c_str() , /* SQL statement, UTF-8 encoded */
> create_table.length(), /* Maximum length of zSql in bytes. */
> &stmt, /* OUT: Statement handle */
> NULL /* OUT: Pointer to unused portion of zSql */
> );
> if(rc != SQLITE_OK) {
> sqlite3_close(db);
> std::cout << "error prepare_v2: " << rc << std::endl;
> exit(-2);
> }
> rc = sqlite3_step(stmt);
> if(rc != SQLITE_DONE) {
> sqlite3_close(db);
> std::cout << "error sqlite3_step: " << rc << std::endl;
> exit(-3);
> }
> sqlite3_finalize(stmt);
> }
> void jme::Runner::AddData(){
> rc = sqlite3_prepare_v2(
> db, /* Database handle */
> dbdata.c_str() , /* SQL statement, UTF-8 encoded */
> dbdata.length(), /* Maximum length of zSql in bytes. */
> &stmt, /* OUT: Statement handle */
> NULL /* OUT: Pointer to unused portion of zSql */
> );
> if(rc != SQLITE_OK) {
> ....
> }
> rc = sqlite3_step(stmt);
> if(rc != SQLITE_DONE) {
> ....
> }
> sqlite3_finalize(stmt);
> }
> void jme::Runner::OpenDB() {
> rc = sqlite3_open_v2(dbName.c_str(),
> &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE,
> NULL);
> if(rc != SQLITE_OK) {
> ....
> }
> jme::Runner::Runner() {
> dbName = "sqliteTest.sql";
> sName = "ArbolOne";
> sAddress = "1 Parkway Rd";
> vfs = "win32";
> age = 22;
> dbdata = "INSERT INTO friend VALUES('Jamiil', '49 New Bridge', '49')";
> create_table = "CREATE TABLE friend (name TEXT, address TEXT, age INT)";
> try {
> jme::gnu_io f;
> f.deleteFile(dbName);
> } catch(jme::Exception e) {
> std::cout << e.what() << std::endl;
> }
> OpenDB();
> CreateTable();
> AddData();
>
> }
> jme::Runner::~Runner(){
> sqlite3_close(db);
> cout << "Good bye!" << endl;
> }
> int main(int argc, char *argv[]) {
> try {
> Gtk::Main kit(argc, argv);
> jme::Runner dbtest;
> Gtk::Main::run(dbtest);
> } catch(jme::Exception& x) {
> x.Display();
> }
> return 0;
> }
> This is what I have done so far, and following your advice I hade added
> 'sqlite3_finalize(stmt)' each time I am done with it. Also, I have downloaded
> and installed 'SQLight Designer' and when opening the database file, I have
> just created, all that I can see is the words: SQLite format 3.
> Come on you folk, you have more experience than me using SQLite, pich in!.
> What else do I need to do?
>
> TIA
>
> void jme::Runner::CreateTable(){
> rc = sqlite3_prepare_v2(
> db, /* Database handle */
> create_table.c_str() , /* SQL statement, UTF-8 encoded */
> create_table.length(), /* Maximum length of zSql in bytes. */
> &stmt, /* OUT: Statement handle */
> NULL /* OUT: Pointer to unused portion of zSql */
> );
> if(rc != SQLITE_OK) {
> sqlite3_close(db);
> std::cout << "error prepare_v2: " << rc << std::endl;
> exit(-2);
> }
> rc = sqlite3_step(stmt);
> if(rc != SQLITE_DONE) {
> sqlite3_close(db);
> std::cout << "error sqlite3_step: " << rc << std::endl;
> exit(-3);
> }
> sqlite3_finalize(stmt);
> }
> _______________________________________________
> 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
