Re: [sqlite] Question about sqlite3_clear_bindings

On 8 Dec 2008, at 11:54 AM, Igor Tandetnik wrote: > Tito Ciuro <[EMAIL PROTECTED]> wrote: >> On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote: >> I'd like to know why sqlite3_clear_bindings () exists in the first place. >>> >>> I don't know. It doesn't look particularly useful to me,

Re: [sqlite] Question about sqlite3_clear_bindings

Tito Ciuro <[EMAIL PROTECTED]> wrote: > On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote: > >>> I'd like to know why sqlite3_clear_bindings >>> () exists in the first place. >> >> I don't know. It doesn't look particularly useful to me, either. > > Looking through the docs, it seems that

Re: [sqlite] Question about sqlite3_clear_bindings

Hi Igor, On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote: >> I'd like to know why sqlite3_clear_bindings >> () exists in the first place. > > I don't know. It doesn't look particularly useful to me, either. Looking through the docs, it seems that sqlite3_clear_bindings() is a convenience

Re: [sqlite] Question about sqlite3_clear_bindings

Tito Ciuro <[EMAIL PROTECTED]> wrote: >>> If step 5 is incorrect, when should I be calling >>> sqlite3_clear_bindings ()? >> >> You don't have to, if you don't want to. > > I'm curious as to why it's not needed. Is it because the latter bind > overrides the former one? Yes. > I'd like to know

Re: [sqlite] Question about sqlite3_clear_bindings

Hi Igor, On 7 Dec 2008, at 10:49 PM, Igor Tandetnik wrote: > You might want to if most of your parameters are NULL, and you just > bind > a some of them. I didn't read your reply carefully enough. It makes sense, thank you. -- Tito ___ sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

Hello Igor, On 7 Dec 2008, at 10:49 PM, Igor Tandetnik wrote: > "Tito Ciuro" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> 1 • Create the object using sqlite3_prepare_v2() or a related >> function. 2 • Bind values to host parameters using the >> sqlite3_bind_*() interfaces. >>

Re: [sqlite] Question about sqlite3_clear_bindings

"Tito Ciuro" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 1 • Create the object using sqlite3_prepare_v2() or a related > function. 2 • Bind values to host parameters using the > sqlite3_bind_*() interfaces. > 3 • Run the SQL by calling sqlite3_step() one or more times. > 4 •

[sqlite] Question about sqlite3_clear_bindings

Hello, I was reading the following pages: http://www.sqlite.org/c3ref/stmt.html http://www.sqlite.org/c3ref/clear_bindings.html I was wondering why sqlite3_clear_bindings() is not mentioned in the SQL Statement Object page. Would the following be incorrect?: 1 • Create the object using