Hi, Simon, On Tue, Dec 27, 2016 at 12:14 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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.
Trying to hardwire the 'leagues' value into the query - everything works. I do get the record. > > 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. I have no idea - "CREATE TABLE \"sys.abcattbl\"();" worked OK. Thank you. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users