Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

> I can’t think of any cases where these would happen if everything was working as planned. I can't think of anything either and this is all fully tested, so I think I can leave these checks out. > From what I can see, you’re executing a long series of queries, each of which you expect to return

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

On 28 May 2017, at 12:14pm, Gwendal Roué wrote: > I personnally call sqlite3_reset before sqlite3_clear_bingings with great > success, but I don't know if the order is relevant or not. It makes more sense to move sqlite3_clear_bindings() to before you set parameters

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

The documentation (https://www.sqlite.org/c3ref/reset.html) seems to suggest that sqlite3_reset can only be unsuccessful if sqlite3_step returned an error. Not sure about sqlite3_clear_bindings. I will do some testing and see if there is any performance gain in leaving these checks out. Very

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

> Le 28 mai 2017 à 13:24, Bart Smissaert a écrit : > >> Calling sqlite3_clear_bindings does the same thing as calling > sqlite3_bind_null for all arguments. > > Yes, I understand that, just thinking about efficiency. Then I don't know. Your experience will tell. >>

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

> Calling sqlite3_clear_bindings does the same thing as calling sqlite3_bind_null for all arguments. Yes, I understand that, just thinking about efficiency. > I personnally call sqlite3_reset before sqlite3_clear_bingings with great success I am doing the same now. Probably no difference there

Re: [sqlite] sqlite3_reset and sqlite3_clear_bindings

Hello Bart, > Le 28 mai 2017 à 13:03, Bart Smissaert a écrit : > > Using SQLite3 3.19.0 on a Windows machine. > I have some general questions about sqlite3_reset and > sqlite3_clear_bindings: > I am processing data from a 2D variant array (this is VB6). > > 1. I

[sqlite] sqlite3_reset and sqlite3_clear_bindings

Using SQLite3 3.19.0 on a Windows machine. I have some general questions about sqlite3_reset and sqlite3_clear_bindings: I am processing data from a 2D variant array (this is VB6). 1. I understand that after processing a row (binding all the values in a row of that variant array) I need to do

Re: [sqlite] sqlite3_reset nor sqlite3_clear_bindings are clearing the auxdata when using sqlite3_set_auxdata

Philip Van Hoof wrote: > When we use our custom SQLite function function_sparql_regex (lower in > this E-mail) together with bound values for the argvs of the function, > then sqlite3_reset nor sqlite3_clear_bindings are clearning the > auxdata. > > This makes it impossible to

[sqlite] sqlite3_reset nor sqlite3_clear_bindings are clearing the auxdata when using sqlite3_set_auxdata

Hi there, When we use our custom SQLite function function_sparql_regex (lower in this E-mail) together with bound values for the argvs of the function, then sqlite3_reset nor sqlite3_clear_bindings are clearning the auxdata. This makes it impossible to pass the regex as a sqlite3_bind_text (the