Re: [sqlite] How do I see a full query?

list > Subject: Re: [sqlite] How do I see a full query? > > Keith, > > On Tue, Dec 27, 2016 at 10:59 PM, Keith Medcalf <kmedc...@dessus.com> > wrote: > > > >> > So whether hard coding the empty string in the query or using a > >> par

Re: [sqlite] How do I see a full query?

Keith, On Tue, Dec 27, 2016 at 10:59 PM, Keith Medcalf wrote: > >> > So whether hard coding the empty string in the query or using a >> parameter (in which you can use some value other than an empty string) >> depends on what you will need in the context of the application.

Re: [sqlite] How do I see a full query?

> > So whether hard coding the empty string in the query or using a > parameter (in which you can use some value other than an empty string) > depends on what you will need in the context of the application. It will, > of course, never return a row in which the abt_ownr field has a value > other

Re: [sqlite] How do I see a full query?

Hi, Simon, On Tue, Dec 27, 2016 at 12:14 AM, Simon Slavin wrote: > > On 27 Dec 2016, at 4:24am, Igor Korot 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:

Re: [sqlite] How do I see a full query?

mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im > Auftrag von Igor Korot > Gesendet: Dienstag, 27. Dezember 2016 05:24 > An: Discussion of SQLite Database <sqlite-users@mailinglists.sqlite.org>; > General Discussion of SQLite Database <sqlite-us...@sqlite.org> >

Re: [sqlite] How do I see a full query?

n empty string is >> a >> value) vs a NULL, see >> https://en.wikipedia.org/wiki/Sql_null >> >> So, in your C code you need to bind an empty string to parameter 2, and in >> the query run in the shell use single-quotes around text values, in order >> for the tw

Re: [sqlite] How do I see a full query?

\'\';"; > > because abt_ownr field will always be empty (unless there is a way to know > what user connected to the DB). > > Also I'm just curious - am I to run something like: > > res = sqlite3_bind_text( stmt, 2, "", -1, SQLITE_STATIC ); > > Thank

Re: [sqlite] How do I see a full query?

Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Igor Korot > Sent: Monday, 26 December, 2016 21:24 > To: Discussion of SQLite Database; General Discussion of SQLite Database > Subject: [sqlite] How do I see a

Re: [sqlite] How do I see a full query?

ce the queries are the same, you should expect identical results. > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Igor Korot > Sent: Monday, 26 December, 2016 21:24 > To: Discussion of SQLite Database; General D

Re: [sqlite] How do I see a full query?

-users-boun...@mailinglists.sqlite.org] Im Auftrag von Igor Korot Gesendet: Dienstag, 27. Dezember 2016 05:24 An: Discussion of SQLite Database <sqlite-users@mailinglists.sqlite.org>; General Discussion of SQLite Database <sqlite-us...@sqlite.org> Betreff: [sqlite] How do I see a full que

Re: [sqlite] How do I see a full query?

On 27 Dec 2016, at 4:24am, Igor Korot 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

[sqlite] How do I see a full query?

Hi, ALL, 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