Actually I am not counting the rows now. I am new to SQLite database. Hence, thought that I should know the number of rows present to retrieve all data in the database one after another. Now I understood how to retrieve data without knowing the number of rows!
-----Original Message----- From: Jonas Sandman [mailto:[EMAIL PROTECTED] Sent: Thursday, June 28, 2007 11:41 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: BLOB data retrieval 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] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
