Thanks, will look at that one and see how it compares to using sqlite3_column_count.
RBS On Mon, Jan 11, 2016 at 7:17 AM, Hick Gunter <hick at scigames.at> wrote: > You may also like to consider sqlite3_stmt_readonly() which will return > TRUE for all statments that do not (directly) modify the db contents > > -----Urspr?ngliche Nachricht----- > Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Bart > Smissaert > Gesendet: Freitag, 08. J?nner 2016 21:28 > An: General Discussion of SQLite Database > Betreff: [sqlite] Can SQLite know from the statement string if it is row > producing or not? > > I am interested to know from the statement string if the statement is > invalid, row producing (could produce rows) or non row producing. I know > sqlite3_prepare16_v2 can see if the statement is valid or not but how > about the other 2? > I can do this in code no problem, but it may not always be 100% reliable > for example there could be a new pragma or maybe some new SQL keyword. > > RBS > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: hick at scigames.at > > This communication (including any attachments) is intended for the use of > the intended recipient(s) only and may contain information that is > confidential, privileged or legally protected. Any unauthorized use or > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please immediately notify the sender > by return e-mail message and delete all copies of the original > communication. Thank you for your cooperation. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
