On 4/27/05, jack wu <[EMAIL PROTECTED]> wrote: > documentation says if > > int sqlite3_step(sqlite3_stmt*); > > returns SQLITE_ROW, (meaning a single row) then i can > use int sqlite3_column_int(sqlite3_stmt*, int iCol); > and other functions to extract the returned values out > of the row. > > can i use the same set of API on a result set which > contains multiple rows? if yes, which API do i call to > move to the next row before calling sqlite3_column_* > again?
Yes. You call step again. Bind your results to variables. execute step repeatedly to retrieve all rows. It returns SQLITE_DONE when you try to fetch past the last row.