On 27 Dec 2016, at 4:24am, Igor Korot <ikoro...@gmail.com> wrote: > I have a weird situation where executing a query in a shell gives me a row, > but executing the same query through the C-interface: sqlite3_prepare_v2(), > sqlite3_bind_text() and sqlite3_step() produces SQLITE_DONE. > > So I wonder - is it possible to see a full query string inside sqlite3_step()?
<https://www.sqlite.org/c3ref/expanded_sql.html> One other way to test what’s going on is to temporarily hardwire your C code to execute the bound string (as you think it is after binding) rather than doing its own binding, and see if you get the same result. When this happens it’s usually because of some weird problem with escaping or quoting characters. Sixteen posts later someone points out that section 14(b)(F) says that after a backslash you have to triple-double-quote. I don’t know if this is what your particular problem is but it happens a lot. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
