That is done by the wrapper class wrapping the sqlite API calls - as I understand. It seems really that I don't have any data, because on failure a simple query without where clause also fails.
As posted here, I'll see what the PRAGMA database_list gives me back. Thanks, Lothar Am 07.09.2008 um 20:17 schrieb John Stanton: > 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 > -- | 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