Hello Lothar, you should indeed get SQLITE_ROW. Can it be that your select statement has a where - clause that does not fir your data? Perhaps you want to post your statements here, beginning with create table.
Martin 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 > > -- * Codeswift GmbH * Traunstr. 30 A-5026 Salzburg-Aigen Tel: +49 (0) 8662 / 494330 Mob: +49 (0) 171 / 4487687 Fax: +49 (0) 12120 / 204645 [EMAIL PROTECTED] www.codeswift.com / www.swiftcash.at Codeswift Professional IT Services GmbH Firmenbuch-Nr. FN 202820s UID-Nr. ATU 50576309 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users