RE: [sqlite] Getting the no of rows using count(*)

2008-01-31 Thread kirrthana M
It works fine..Thanks.. Kirrthana -Original Message- From: Bharath Booshan L [mailto:[EMAIL PROTECTED] Sent: Thursday, January 31, 2008 12:07 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Getting the no of rows using count(*) Hello Kirrthana, > should i use prepare and s

Re: [sqlite] Getting the no of rows using count(*)

2008-01-30 Thread Bharath Booshan L
Hello Kirrthana, > should i use prepare and step in this case and where the result of the query > will be stored on executing my c code. retValue = sqlite3_prepare( dataBaseConnection ,sqlQuery,-1, ,0); if( retValue != SQLITE_BUSY && (retValue = sqlite3_step( ppStmt ) == SQLITE_ROW ) {