On Sun, Mar 25, 2012 at 06:10:14PM +0800, Neo Anderson scratched on the wall: > > Is it possible to handle multiple results using sqlite3_step or any > other API calls?
sqlite3_exec() is the only API call that will process multiple SQL statements in a single call. Its use is somewhat discouraged, however. All output values are converted to strings, losing any type information. In the case of multiple statements, there is no deliminator between the result sets. Also, since it does not support statement parameters *and* processes multiple statements in one pass, its use is much more prone to significant SQL injection attacks. As I understand it, the call mainly exists for backwards compatibility with SQLite2. While the call is not actually deprecated, new development is encouraged to use the prepare/step/finalize APIs. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
