-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 aditya siram wrote: > Once a sqlite3_stmt has been prepared and variables bound, is there some way > of extracting the SQL query?
http://www.sqlite.org/c3ref/sql.html > So something in the way I am > binding the variables is returns zero rows. I would like to see the final > SQL before it is run. You may be thinking that somehow the SQL query has the bound values applied into it as text. That is not the case - SQLite works with the query and the bound values as is (separately). Some common gotchas that may be the underlying cause: - - Not checking the result of every call - - Bound variable numbering starts at one not zero - - Bound variables default to null until you override them - - Null values can give unexpected results (eg null is not equal to null) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkmKz30ACgkQmOOfHg372QSqdQCbBGW+xsDusCoVye6X3Ls91Xm0 I8cAnjO73Q+Q22VTQ3LHJoycjv0bnKRs =df0M -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users