Indiff3rence wrote: > My question is: why is necessary to reset the statement before I can rebind > it? > It should work only if I clear the old bind, no? > > You need to reset the statement so that it can be executed again from the beginning (see section 3.0 of http://www.sqlite.org/cintro.html for more details).
You do not need to clear the old bindings if you are going to bind new values for each of the variables before you execute the command again. The clear binding call basically binds a NULL to each variable, which you are overwriting anyway. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
