[sqlite] how to get the number of rows in a a table?

how to get the number of rows in a a table? what is the function to get that? Please add a sample code to achive that. thanks dmsmsm -- View this message in context: http://old.nabble.com/how-to-get-the-number-of-rows-in-a-a-table--tp29216126p29216126.html Sent from the SQLite mailing list

[sqlite] how to retrieve the result of an sqlite_exec()

char *err; if (sqlite3_exec(db, [rowcount UTF8String], NULL, NULL, ) != SQLITE_OK) { sqlite3_close(db); NSAssert(0, @"Failed to get Number of Rows"); } here in this code, from where can i extract the row count.. Please help!!! dmsmsm -- View this message in context: http: