Re: [sqlite] Re: - [sqlite] WHERE expression problem

kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com ****

Re: [sqlite] WHERE expression problem

tring, if the column type is explicitely created to be an integer? Thanksm Eno [EMAIL PROTECTED] wrote: Eno Thereska <[EMAIL PROTECTED]> wrote: Hi, I noticed the following strange problem when the expression to WHERE contains clauses that refer to the same column. Here are three

Re: [sqlite] Re: - [sqlite] WHERE expression problem

essage and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com *****

[sqlite] WHERE expression problem

Hi, I noticed the following strange problem when the expression to WHERE contains clauses that refer to the same column. Here are three queries and their output: select count(*) from table1 where ((timestamp >13448180261410868) and (timestamp <= 13448182164507680)); output: 100 select cou

Re: [sqlite] any lightweight linux DB browser

Something with a GUI would be ideal. I agree that the sqlite3 tool is very lightweight, unfortunately it has no GUI. Thanks, Eno juan perez wrote: You can't get any lighter than the sqlite3 tool that ships with SQLite3. Can you be more specific in terms of what you need? Eno The

[sqlite] any lightweight linux DB browser

Hi, I am using sqlitebrowser, but it eats up a lot of memory. For some reason it decides to cache query results and has a caching policy which works well for DBs that fit in memory, but doesn't otherwise. I am looking to patch it. Meanwhile, if anyone has seen similar patches or knows of a b

[sqlite] getting table size

Hi, Is there a SQL query that returns the size in bytes a table occupies? Thanks Eno

Re: [sqlite] Tool to load a database and see all tables and fields.

just lists the tables and fields in a database. I have tried sqlitemanager, but I didn't really liked it. -- Eno Thereska - Carnegie Mellon University Parallel Data Laboratory CIC Building Cube 2221-D 5000 Forbes Ave Pittsburgh, PA 1521

Re: [sqlite] Tool to load a database and see all tables and fields.

at just lists the tables > and fields in a database. I have tried sqlitemanager, but I didn't really > liked it. > > Greetings koen (spudse). > -- Eno Thereska - Carnegie Mellon University Parallel Data Laboratory CIC

[sqlite] completion of sqlite3_exec

Hi, Is there a way to know if a row returned through the callback to sqlite3_exec is the "last" row that will be sent (i.e. the query has finished completely)? I ask because I have per-query data structures that I need to free once I know a query has completed. I was expecting the callback f