On Sat, May 4, 2013 at 8:59 AM, Stephan Beal <sgb...@googlemail.com> wrote:
> Consider this SQL > snippet: > > UPDATE foo SET x=:param1, y=:param1 ... > > As i understand it (possibly incorrectly!), the bind-by-param-name API will > properly set both instances of ":param1", but as far as i can find there is > no way to programatically get both indexes: sqlite3_bind_parameter_index() > will return only the first index: > There is only one index to get. If you use the same parameter name (say ":param1") N times in the same statement, then you only have to bind it once and all N instances of that parameter take on the same value. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
