On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote: > Is there any API that will return number of rows (records) > present in a particular table. I want to access the table using its database > name and corresponding table.
Nope. It's quite difficult doing that in SQLite because of how the data are stored. The fastest way is to use the API to run SELECT COUNT(*) FROM thisTable just the same as you would any other SELECT statement. If you have multiple databases attached then, of course, use SELECT COUNT(*) FROM thisDatabase.thisTable Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
