On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers <rob.my...@ziften.com> wrote:
> Aiiiiggggghhh (just kidding) > > One request for a change - make bind and column start with the same index. > I always have to look up which one is zero based and which one is one based. > Right now, porting an app from SQLite3 to SQLite4 is mostly a global search/replace of "sqlite3"->"sqlite4". (Maybe a little more than that<http://www.sqlite.org/src4/doc/trunk/www/porting.wiki>but not much.) Changing the index base for sqlite4_bind would really complicate matters. Recommend you not use sqlite4_bind() directly, but rather us named parameters (ex: "@one", ":two", "$three") with sqlite4_bind_parameter_index(): sqlite4_bind_int(pStmt, sqlite4_bind_parameter_index(pStmt, "$three"), 3); That way, you never have to worry about miscounting the "?" parameters in your query and being off-by-one in your bindings. > > Rob > > > On 6/28/2012 10:57 AM, Simon Slavin wrote: > >> First, the important bit: >> >> "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is >> not going away." >> >> Now the URL: >> >> <http://www.sqlite.org/src4/**doc/trunk/www/design.wiki<http://www.sqlite.org/src4/doc/trunk/www/design.wiki> >> > >> >> Just thought some people might enjoy reading and thinking about it. >> >> Simon. >> ______________________________**_________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >> > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
