Re: [sqlite] C++ - WHERE clause - update

2012-09-07 Thread Simon Slavin
On 7 Sep 2012, at 2:18pm, Rob Richardson wrote: > One number (I don't know off hand which) is labeled SQLITE_ROW, which you are > using. Another is SQLITE_DONE. Another is SQLITE_MISUSE. There are several > of them. Quite right.

Re: [sqlite] C++ - WHERE clause - update

2012-09-07 Thread Rob Richardson
No, it is absolutely not a trick question. Just tell us the number that sqlite3_step() returned. It is a question about what the actual value was that was returned by the call to sqlite3_step(). The function returns a number that indicates whether it worked or not. There are values defined

Re: [sqlite] Read-only media

2012-09-07 Thread Simon Slavin
On 7 Sep 2012, at 1:19pm, Steinar Midtskogen wrote: > [Richard Hipp] > >> If the last writer to the database file crashed and left a hot >> journalthen the >> next reader to come along must rollback that journal before

Re: [sqlite] Read-only media

2012-09-07 Thread Steinar Midtskogen
[Richard Hipp] > If the last writer to the database file crashed and left a hot > journalthen the > next reader to come along must rollback that journal before it can > start reading, and that will require write access. Can similar things

Re: [sqlite] C++ - WHERE clause - 2nd update

2012-09-07 Thread Black, Michael (IS)
You're example should work if you only prepare the statement once. So assuming mystmt is set to NULL on your object creation. if (mystmt == NULL) { rc = sqlite_prepare_v2. } Then reset it to NULL again when you set apstr="finished". After sqlite3_finalize(mystmt). That way you're next

Re: [sqlite] C++ - WHERE clause - 2nd update

2012-09-07 Thread Arbol One
Yes, thank? I gave you the answer you gave me, obviously I was right. I need you to prove me right again, how about, haaa yes! if 2x2 is 4, what is 2x2? Come on! I know you can get it, just try going slowly this time. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] C++ - WHERE clause - 2nd update

2012-09-07 Thread Marcus Grimm
On 07.09.2012 08:58, Arbol One wrote: I got this code to work, however, I am getting a segmentation fault on this code. I pass to SQLite only one statement [db->setStmt(apstr);], I read the first of the 'fname', but I don't know how to get to the second 'fname' in the database. I am not very

[sqlite] C++ - WHERE clause - 2nd update

2012-09-07 Thread Arbol One
I got this code to work, however, I am getting a segmentation fault on this code. I pass to SQLite only one statement [db->setStmt(apstr);], I read the first of the 'fname', but I don't know how to get to the second 'fname' in the database. I am not very sure as to what do to tell the program to