Hello Lothar, yes, PRAGMA database_list will show you the database the handle is attaches with. Treat tis statement as a Select - Statement, ist returns at least one row of data, and the field "file" contains the filename of the database.
Martin Lothar Behrens wrote: > It is a bit too complex to show my code, because the sqlite2_* > functions are wrapped two layers deeper than my code is using. > Also the code is in a GUI that supports 'cursors'. > > Basically I can use the application and the table whose statement will > fail to get any rows later, shows me the expected data before > re-issuing the query. But this re-issuing is also done on other places > in my application with no failure. That makes me wonder. > > Now I have tried to remove existing where clauses in case of no data > and do report an error message when then also no data is available. > > It fails too. > > I also tried to figure out if I am in the right database file, but > that was ok by the way I checked that. > > A question: Could I query for the database file from the current > sqlite database handle ? > > Thanks > > Lothar > > PS. If nothing helps, I'll try to setup a test case for this with > plain sqlite commands, as they appear in my program flow. > > Am 07.09.2008 um 14:17 schrieb Martin Engelschalk: > > >> 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 >> >> > > -- | 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
