[sqlite] Collecting return values from sql commands using SQLite APIs.

2012-01-19 Thread bhaskarReddy

Hi Friends,

   is it possible to collect return value of a SQL command. ex:
SELECT COUNT(*) FROM table;  will return number of records in a table. Is
there any SQLite API to return this value.

Regards,
Bhaskar Reddy. 
 
  
-- 
View this message in context: 
http://old.nabble.com/Collecting-return-values-from-sql-commands-using-SQLite-APIs.-tp33166706p33166706.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Collecting return values from sql commands using SQLite APIs.

2012-01-19 Thread Max Vlasov
On Thu, Jan 19, 2012 at 1:49 PM, bhaskarReddy uni...@gmail.com wrote:


 Hi Friends,

   is it possible to collect return value of a SQL command. ex:
 SELECT COUNT(*) FROM table;  will return number of records in a table. Is
 there any SQLite API to return this value.


It's the same api that returns values for
  SELECT * FROM table;
Only for Count(*) you result is one row and one column

Max
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users