You get ROW if there is a row available, DONE if there are no rows, or all the rows have been extracted. Your program needs to test for both states.
Lothar Behrens wrote: > Hi, > > I am struggling with the following situation: > > I have a table where two rows are inserted. I create a new prepared > select statement to get a resultset. > > After getting the resultset I issue a sqlite3_step to see, if I hava > any data. Thus of two rows I assume to get > SQLITE_ROW. > > But I get SQLITE_DONE. > > My questions: > > After getting SQLITE_DONE, do I still have a row in my result set as > the last row for any sqlite3_step calls ? > > Is so, am I allowed to read the columns of this row after a > sqlite3_reset has been issued ? > > Is SQLITE_DONE a flag to be handled as the following SQLITE_ROW + > 'have the last row now' ? > > Thanks > > Lothar > > -- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de > Lothar Behrens > Heinrich-Scheufelen-Platz 2 > 73252 Lenningen > > > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users