Re: [sqlite] MIN() for a timedelta?

2012-07-28 Thread C M
Thanks everyone for the various replies and help. Very useful and I will look into the differences and if I have questions about how these work will let you know. Thank you, Che ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] How to query data in table more than 2?

2012-07-28 Thread Igor Tandetnik
黃楨民 wrote: > I would like to query customer from from ooder table and only customer > order more than twice. select CustomerId from Orders group by CustomerId having count(*) > 2; -- Igor Tandetnik ___ sqlite-users mailing

Re: [sqlite] Could anyone recommend books for SQLite

2012-07-28 Thread Peter Aronson
There's a page on the SQLite website about SQLite books at http://www.sqlite.org/books.html. I own the first two on the page, and like them both. If I was only to get one SQLite book, it'd be the second one on the list: Using SQLite by JayKreibich. Best, Peter On 7/28/2012 6:44 PM, 黃楨民

[sqlite] How to query data in table more than 2?

2012-07-28 Thread 黃楨民
Dear all: I would like to query customer from from ooder table and only customer order more than twice. Which clause or filter should I use to filter those customer order more than twice ? Please help Best regards tom ___ sqlite-users mailing list

[sqlite] Could anyone recommend books for SQLite

2012-07-28 Thread 黃楨民
Dear all I am looking for a book ,which include all instructures and functions of SQLite. It is like reference guide. Could any help? your sincerely tom ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] C++ - Finalizing my SQLite interface

2012-07-28 Thread Black, Michael (IS)
Or since in C++ use an unordered_map. Add your statement pointers to that, and delete them from the map when finalized. Then walk through that map on destruction to finalize all you haven't cleaned up yourself. Given the way he's developing I would make a function to do this that pre-checks