subject:"\[sqlite\] How to get record count"

Re: [sqlite] How to get record count

2007-12-12 Thread Marco Bambini

SELECT count(*) FROM myTable; --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Dec 12, 2007, at 2:55 PM, Tom Parke wrote: How can I get a count of the number of records in a table? Sqlite3_get_table() might work, but I only need the

[sqlite] How to get record count

2007-12-12 Thread Tom Parke

How can I get a count of the number of records in a table? Sqlite3_get_table() might work, but I only need the count, not the record set. Thanks, Tom