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

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

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 w

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: > > h

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"),(sqlErrMs

[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 P

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* pSt

[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 versio