Re: [sqlite] using sqlite3_get_table --additional info...

2011-03-31 Thread Michael Steiger
On 31.03.2011 16:30 john darnell said the following: > BTW, if there is a better way to get a row count without using > sqlite3_get_table() that would also work. This will work withput fetching the table dbrc = sqlite3_prepare_v2 (db, "select count(*) from table", -1, , NULL); if

Re: [sqlite] using sqlite3_get_table --additional info...

2011-03-31 Thread Mr. Puneet Kishor
On Mar 31, 2011, at 9:30 AM, john darnell wrote: > BTW, if there is a better way to get a row count without using > sqlite3_get_table() that would also work. maybe I am missing something, but what is wrong with "SELECT Count(*) FROM table"? > >

[sqlite] using sqlite3_get_table --additional info...

2011-03-31 Thread john darnell
BTW, if there is a better way to get a row count without using sqlite3_get_table() that would also work. _ From: john darnell Sent: Thursday, March 31, 2011 9:27 AM To: 'General Discussion of SQLite Database' Subject: using sqlite3_get_table All I