Re: [sqlite] retrieve num-rows from a result

2007-01-01 Thread John Stanton
You need to count the number of rows as you sqlite3_step and get each one. A DB only knows how many rows are in a selection after it has read them all. Ohad Eder-Pressman wrote: just started using sqlite through a c++ wrapper. i need to be able to know how many rows are contained in a

Re: [sqlite] retrieve num-rows from a result

2007-01-01 Thread Roger Binns
Ohad Eder-Pressman wrote: just started using sqlite through a c++ wrapper. i need to be able to know how many rows are contained in a result, is this possible ? i've looked through the c api and can find only a 'number of rows affected' when inserting/deleting, nothing about num-rows of a select

[sqlite] retrieve num-rows from a result

2007-01-01 Thread Ohad Eder-Pressman
just started using sqlite through a c++ wrapper. i need to be able to know how many rows are contained in a result, is this possible ? i've looked through the c api and can find only a 'number of rows affected' when inserting/deleting, nothing about num-rows of a select