On 6/8/15, Ward Willats <sqlite-users at wardco.com> wrote: > Can a prepared statement have more than 1 statement in it (and bind > parameters across the whole thing)? > > Something like: > > prepare_v2( h, "one statement ? ; two statement ?", -1, &s, NULL )
No. A prepared statement is *one* SQL statement, not more than one. > > bind_int( s, 1, 9999 ) > bind_int( s, 2, 9999 ) > > (I ask because I am getting a SQLITE_RANGE (25) error just after a ";" in a > compound statement I've compiled with a param I've bound earlier...) > > Thanks, > > -- Ward > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org
