Thank you very much. Now that you cleared that for me I need to look in my code why simple query like "select * from table x" works fine but as soon as I call "select * from table x where value=1" is only returning the last line from the file.
Thank you Darek -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich Sent: Friday, February 25, 2011 11:00 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Virtual Table and the xBestIndex On Fri, Feb 25, 2011 at 09:30:00PM -0500, Dariusz Matkowski scratched on the wall: > I am trying to implement a simple virtual table that reads in a file > with two columns and "::" separator. My question is: is it necessary > to implement xBestIndex to run a simple where clause queries? You must implement a xBestIndex() function, but it does not need to do anything other than return SQLITE_OK. This will result in a full table scan for each query, but for something like a flat file (where you cannot easily jump to specific records) that's usually not a significant limitation. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users --------------------------------------------------------------------- This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users