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, either. >> >> Looking through the docs, it seems that sqlite3_clear_bindings() is a >> convenience function for int sqlite3_bind_null(sqlite3_stmt*, int). >> So >> if you have N columns, instead of clearing them one by one >> sqlite3_clear_bindings() does that for you in one call. > > Well, yes. I know this. The question is, when, in practice, would you > want to set all parameters to NULL?
Well, probably never :-) However, if the majority of the columns need to be cleared, it's probably easier to clear all of them and rebind the ones needed... -- Tito _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users