Re: [sqlite] Can't get results from PRAGMA

2007-02-15 Thread Paul Simpson
Hi, (I hope we are not getting off-topic) We seem to be, sorry everyone! I trued e-mailing you directly - I hope you don't mind, but your mail server refused the mail! (I'm using Code::Blocks IDE. If you wish I can send sqlite project file for it. Project file has gcc,vc,bcc,dmc release and

Re: [sqlite] Storing contacts list for each user

2007-02-15 Thread Paul Simpson
/home/user/user1/user1.db [User1 will have table to hold contacts list] /home/user/user2/user2.db [User2 will have table to hold contacts list] . . . /home/user/userN/userN.db [UserN will have table to hold contacts list] This would imply that you are writing an application where each user

[sqlite] Can't get results from PRAGMA

2007-02-14 Thread Paul Simpson
Hi, I'm trying to use the dll version of SQLite within an application written in C++ using wxWidgets. I couldn't get the callback function working using C++, so I am trying to use the prepare / step etc. series of functions. OK, when my user opens a file, I want to make use of the USER_VERSION

Re: [sqlite] Can't get results from PRAGMA

2007-02-14 Thread Paul Simpson
wxString getDBVersion = PRAGMA user_version = 2;; rc = (sqlPrepareAdd)(newdb,getDBVersion.c_str(),getDBVersion.length(), pStmt, pzTail); if(rc != SQLITE_OK){ wxString msg; msg.Printf(wxT(Can't process database: %s),(sqlErrMsgAdd)(newdb));

Re: [sqlite] Can't get results from PRAGMA

2007-02-14 Thread Paul Simpson
Hi, Paul Simpson wrote: Hi, I'm trying to use the dll version of SQLite within an application written in C++ using wxWidgets. [snip] In case you missed, there is already an interface: http://wxcode.sourceforge.net/components/wxsqlite3 -- Regards, Hakki Dogusan Yes, I did

Re: [sqlite] Can't get results from PRAGMA

2007-02-14 Thread Paul Simpson
Hi, Paul Simpson wrote: Hi, Paul Simpson wrote: Hi, I'm trying to use the dll version of SQLite within an application written in C++ using wxWidgets. [snip] In case you missed, there is already an interface: http://wxcode.sourceforge.net/components/wxsqlite3 -- Regards

[sqlite] New (ish) to C== and new to SQLite error with prepare.

2007-02-13 Thread Paul Simpson
Hi, I'm (fairly) new to C++ and also to using dlls and SQLite etc. etc. Ok, so I have a class which represents my database connection. When the open() method is called, it should open the SQLite database. This works. Next, I wnt to use the PRAGMA user_version command to see if the database

Re: [sqlite] Re: New (ish) to C== and new to SQLite error with prepare.

2007-02-13 Thread Paul Simpson
Paul Simpson [EMAIL PROTECTED] wrote: sqlite3_stmt **ppStmt; const char **pzTail; rc = (sqlPrepareAdd)(newdb, getDBVersion.c_str(),getDBVersion.length(),ppStmt,pzTail); Make it sqlite3_stmt* pStmt; const char* pzTail; rc = (sqlPrepareAdd)(newdb, getDBVersion.c_str