Still would be nice to know why you feel like stepping through the
whole lot to count rows?

On 6/28/07, Krishnamoorthy, Priya (IE10)
<[EMAIL PROTECTED]> wrote:
Thanks all for the help.
I fixed the problem by stepping through one row after another.
Thanks a lot.
Priya

-----Original Message-----
From: Trevor Talbot [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 28, 2007 11:35 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] FW: BLOB data retrieval

On 6/27/07, Krishnamoorthy, Priya (IE10)
<[EMAIL PROTECTED]> wrote:

> I am writing a program (in MS VC++) which has to read the blob data in
> all the rows of the above mentioned table one after another. I am
using
> cppSQLite3 which is C++ wrapper function for accessing sqlite3 db.
Mine
> is an offline program that reads the data in the database which is
> updated by another program.

> Please let me know how I can go about doing this?

In the interest of being helpful, I should probably mention that the
standard way of doing this in concept is:

begin query "select BlobColumn from table;"
while not at end of rows in result
    get blob data for current row
    move to next row

------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to