[sqlite] Dumb statement question...

[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. C[++] (Perl)/SQL9_/JavaScript et al}.
Most developers of systems and/or applications are happy to answer those kind 
of questions and more, I guess (an understatement, I'm almost sure about it).

Kind regards |?Cordiali saluti | Vriendelijke groeten | Freundliche Gr?sse,
Klaas `Z4us` V ?- OrcID -0001-7190-2544

[sqlite] Dumb statement question...

[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, &s, NULL )

No.  A prepared statement is *one* SQL statement, not more than one.

>
> bind_int( s, 1,  )
> bind_int( s, 2,  )
>
> (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

[sqlite] Dumb statement question...

[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, &s, NULL )

bind_int( s, 1,  )
bind_int( s, 2,  )

(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