Hello Lothar, sorry, i did not read your questions fully.
No, after you get SQLITE_DONE, you do not have any data in your result set. After issuing sqlite_reset, you can not read any data, the statement Use the statement like this: - sqlite3_prepare the statement. - Use sqlite3_bind_xxx to set your bind variables - execute sqlite_step() while it returns SQLITE_ROW and read the data. If it returns SQLITE_DONE, - sqlite3_finalize() your statement or sqlite3_reset() ist to execute it again, perhaps with other bind variable values. 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
