Hi! As far as I understandd, sqlite3_step() does not fetch any data but returns SQLITE_ROW. If this is the case, then use sqlite3_column() to fetch the actual data.
Marian Cascaval ________________________________ From: Sunil Bhardwaj <sbhard...@ipolicynetworks.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Thu, January 13, 2011 12:42:46 PM Subject: Re: [sqlite] How SQLite manages result of a SELECT query? Hi Let me rephrase my question. We are using in-memory db. When we do "execQuery": 1. Does sqlite fetches complete result of query and keep it in separate memory 2. OR Does sqlite fetches result of query in chunks, when we use "sqlite3_step" and keep it in separate memory 3. OR Does sqlite fetches records one by one, when we use "sqlite3_step" Please help us to understand, how can we use it efficiently. Thanks Sunil Bhardwaj Ext. 1125 (0120-2567001) 9818868910 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ian Hardingham Sent: Thursday, January 13, 2011 4:07 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] How SQLite manages result of a SELECT query? That seems like kind of a broad question. On 13/01/2011 10:33, Sunil Bhardwaj wrote: > Hi > > Please help us to understand, how SQLite manages result of a SELECT query: > - We are using in-memory db, > - > - When we do "execQuery", what operations are internally done in SQLite > > Thanks > Sunil Bhardwaj > Ext. 1125 (0120-2567001) > 9818868910 > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] >On Behalf Of Madhurima . > Sent: Thursday, January 13, 2011 3:30 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] partitioning SQLite database > > I am working on embedded system and the device has linux kernel with sqlite >database. Wanted to know if the sqlite database can be partitioned with secure >and normal partitions. > > How can the encryption be achieved for sqlite database file in linux. > > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] >On Behalf Of Simon Slavin > Sent: Thursday, January 13, 2011 3:18 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] partitioning SQLite database > > > On 13 Jan 2011, at 6:08am, Madhurima . wrote: > >> Is it possible to have partition in SQLite database? > The word 'partition' is used for more than one meaning. You might be talking >about spreading the data about, or grouping results from a SELECT command. >Could you give an example or a reference to documentation ? > > Simon. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > "DISCLAIMER: This message is proprietary to Aricent and is intended solely > for >the use of the individual to whom it is addressed. It may contain privileged >or >confidential information and should not be circulated or used for any purpose >other than for what it is intended. If you have received this message in >error, >please notify the originator immediately. If you are not the intended >recipient, >you are notified that you are strictly prohibited from using, copying, >altering, >or disclosing the contents of this message. Aricent accepts no responsibility >for loss or damage arising from the use of the information transmitted by this >email including damage from virus." > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users