[sqlite] Dumb statement question...

2015-06-10 Thread Klaas V
Someone chose a title like 'Dumb%question%' FYI: Except perhaps of those unasked there is no such thing as a dumb question Especially if a question concerns the great field of ICT whether it's libraries like SQLite, programming compiled (or interpreted)/database/script languages {resp. e.g.

[sqlite] Dumb statement question...

2015-06-08 Thread Richard Hipp
On 6/8/15, Ward Willats 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, , NULL ) No. A prepared statement is *one* SQL statement, not more than one.

[sqlite] Dumb statement question...

2015-06-08 Thread Ward Willats
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, , NULL ) bind_int( s, 1, ) bind_int( s, 2, ) (I ask because I am getting a SQLITE_RANGE (25) error just