On Fri, Jun 22, 2012 at 1:03 AM, deltagam...@gmx.net <deltagam...@gmx.net>wrote:
> sqlite3_prepare_v2() > <http://sqlite.org/c3ref/**prepare.html<http://sqlite.org/c3ref/prepare.html>>, > sqlite3_step() > <http://sqlite.org/c3ref/step.**html<http://sqlite.org/c3ref/step.html>>, > and sqlite3_finalize() > <http://sqlite.org/c3ref/**finalize.html<http://sqlite.org/c3ref/finalize.html> > >, > > From the documentation I saw, that sqlite3_exec "includes" > sqlite3_prepare_v2 , sqlite3_step, sqlite3_finalize. > But if the select_statement contains some variables to bind, is it > possible to use then the wrapper sqlite3_exec ? > > If the select_statement would be > select_statement = "SELECT id, eventdate, eventtype, counter FROM eventlog > WHERE eventdate BETWEEN ? AND ?"; > > how would I use the wrapper sqlite3_exec ? > It is not possible to use sqlite3_bind_xxxx() with sqlite3_exec(). Any variables in the sqlite3_exec() SQL will have the value of NULL. > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users