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] -----------------------------------------------------------------------------