That's kind of cool, but how about $twentyseven!
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users