Re: [sqlite] C++ - HOW MANY rows?

2012-09-12 Thread Igor Tandetnik
On 9/12/2012 1:31 PM, Arbol One wrote: Just so that we are clear, I don't mind trying and failing a thousand times, Well, the participants in this list might not possess quite as infinite a patience. If you plan to post a "what am I doing wrong" type of message to the list a thousand times

Re: [sqlite] C++ - HOW MANY rows?

2012-09-12 Thread Arbol One
n...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Arbol One [arbol...@gmail.com] Sent: Tuesday, September 11, 2012 9:44 PM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] C++ - HOW MANY rows? Thanks Igor for your prompt response. Since the call to the sqlite3_

Re: [sqlite] C++ - HOW MANY rows?

2012-09-12 Thread Simon Slavin
On 12 Sep 2012, at 6:31pm, Arbol One wrote: > Look, Sir, I appreciate that you have spend your time and energy responding > to my question, in fact, I have used your suggestion to have a look at the > other guys' C++ wrappers of the SQLite3 library, but my intention is to >

Re: [sqlite] C++ - HOW MANY rows?

2012-09-12 Thread Arbol One
much for your help and have a wonderful day. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Tuesday, September 11, 2012 11:24 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ - HOW MANY rows? Arbol

Re: [sqlite] C++ - HOW MANY rows?

2012-09-12 Thread Black, Michael (IS)
qlite.org [sqlite-users-boun...@sqlite.org] on behalf of Arbol One [arbol...@gmail.com] Sent: Tuesday, September 11, 2012 9:44 PM To: 'General Discussion of SQLite Database' Subject: EXT :Re: [sqlite] C++ - HOW MANY rows? Thanks Igor for your prompt response. Since the call to the sqlite3_

Re: [sqlite] C++ - HOW MANY rows?

2012-09-11 Thread Igor Tandetnik
Arbol One wrote: > Since the call to the sqlite3_step function is inside the mySQLite3::read_* > class-function/method ... it is clear that you have a poor class design. As you would generally want to read several columns from the same row, it is unwise to have a read_*

Re: [sqlite] C++ - HOW MANY rows?

2012-09-11 Thread Arbol One
Thanks Igor for your prompt response. Since the call to the sqlite3_step function is inside the mySQLite3::read_* class-function/method, I call the read_* method from Runner::read_tblName() for each datum I need to retrieve. Now, in a while loop inside Runner::read_tblName() I could call the

Re: [sqlite] C++ - HOW MANY rows?

2012-09-11 Thread Igor Tandetnik
On 9/11/2012 7:37 PM, Igor Tandetnik wrote: On 9/11/2012 7:28 PM, Arbol One wrote: This works just fine, but it only reads the first row Of course. You only ever call sqlite3_step step after prepare and before finalize. I mean, you only ever call sqlite3_step *once* after prepare and before

Re: [sqlite] C++ - HOW MANY rows?

2012-09-11 Thread Igor Tandetnik
On 9/11/2012 7:28 PM, Arbol One wrote: This works just fine, but it only reads the first row Of course. You only ever call sqlite3_step step after prepare and before finalize. how can I 'tell' my program HOW MANY rows are there to be read and which row I WANT TO READ? You are supposed to